java链接数据库操作:
建立java工程,新建一个包、类,写一个DBUtils类,代码如下:
package jbdcTest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;
public class DBUtils {
private static String driverClass;
private static String url;
private static String user;
private static String password;
static{
//此对象是用来加载properties文件数据的
ResourceBundle rb = ResourceBundle.getBundle("dbinfo");
//给上面4个变量赋值
driverClass = rb.getString("driverClass");
url = rb.getString("url");
user = rb.getString("user");
password = rb.getString("password");
try {
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
//得到连接
public static Connection getConnection() throws SQLException{
return DriverManager.getConnection(url, user, password);
}
//关闭资源
public static void closeAll(ResultSet rs,Statement stmt,Connection conn){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
stmt = null;
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
}
}
在这之前,我们要导入一个JBDC的jar包,不导入会报错,
同时在src中需要建立一个properties文件,因为我们写的类中需要用到这个文件,写这个文件的目的是为了我们方便链接更改数据库,而不需要更改代码,
在我们需要链接数据库的时候,创建另一个类,利用DBUtils的对象调用就可以。
package jbdcTest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class test {
public static void main(String[] args) throws SQLException {
System.out.println("nihao ");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
//获取连接Connection
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb1", "root", "root");
//得到执行sequel语句的对象Statement
Statement stmt = conn.createStatement();
//执行sql语句,并返回结果
ResultSet rs = stmt.executeQuery("select Mneike,Mwaike,Hneike,Hwaike from doctors");
System.out.println("nihao ");
System.out.println(rs.getInt("Mneike"));
while(rs.next()) {
System.out.println(rs.getInt("Mneike"));
}
}
}