java 连接 mysql TestJDBC {
来源:互联网 发布:高考物理满分知乎 编辑:程序博客网 时间:2024/05/21 14:45
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) {
ResultSet rs = null;
Statement stmt = null;
Connection conn = null;
try {
String URL = "jdbc:mysql://127.0.0.1:3306/multi";
String user = "root";
String password = "123";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT Rbh,Rgly,Rlx,Rbz FROM RJBB");
while (rs.next()) {
System.out.print(rs.getString("Rbh"));
System.out.print(rs.getString("Rgly") + " ");
System.out.print(rs.getString("Rlx") + " ");
System.out.print(rs.getString("Rbz") + " ");
System.out.print("\n");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public class TestJDBC {
public static void main(String[] args) {
ResultSet rs = null;
Statement stmt = null;
Connection conn = null;
try {
String URL = "jdbc:mysql://127.0.0.1:3306/multi";
String user = "root";
String password = "123";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT Rbh,Rgly,Rlx,Rbz FROM RJBB");
while (rs.next()) {
System.out.print(rs.getString("Rbh"));
System.out.print(rs.getString("Rgly") + " ");
System.out.print(rs.getString("Rlx") + " ");
System.out.print(rs.getString("Rbz") + " ");
System.out.print("\n");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
- java 连接 mysql TestJDBC {
- Testjdbc
- TestJdbc
- TestJDBC
- TestJDBC(22)
- 【Java】Java连接MySql
- java连接MySql数据库!
- JAVA 连接 MySQL 数据库
- java连接mysql
- java,jsp连接mysql
- java连接mysql
- java连接mysql数据库
- java连接mysql数据库
- JAVA连接MYSQL配置
- java连接mysql数据库
- java连接mysql
- Java连接MySQL数据库
- JAVA 连接MySQL
- Unix常用命令
- 网页中插入电子地图的方法
- nfs:server is not responding,still trying !!原因及解决方法
- 基于SIM300和S3C2410的短信收发问题-3
- 基于SIM300和S3C2410的短信收发问题-2(AT指令篇-1)
- java 连接 mysql TestJDBC {
- 10米USB延长线制作方法
- Google maps API开发
- 请进入网盘的各位童鞋,为了他人
- 考研网址集
- 曲师大校友
- 东北大学信息学院08级本科内推研究生名额
- 东北大学研究生导师信息(部分)
- Java编程中“为了性能”尽量要做到的一些地方《转载》