java数据库连接

来源：互联网发布：linux pyqt4 安装编辑：程序博客网时间：2024/06/05 20:35

数据库连接类，连接一个叫jw1014的数据库

package MysqlConntion;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class DBcon {
public static String drive="com.mysql.jdbc.Driver";
public static String url="jdbc:mysql://127.0.0.1:3306/jw1014";
public static String user="root";
public static String col = "6666";
static{
try {
Class.forName(drive);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public boolean con(String name,String pwd){
Connection con = null ;
boolean b = false;
try {
con = DriverManager.getConnection(url,user,col);
String sql="select* from user where loguser = ? and pwd = ?";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pwd);
ResultSet rs = ps.executeQuery();
while(rs.next()){
b = true;
}
rs.close();
ps.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return b;

}

}

1 0