package test.hrm;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Basehrm {
public static Connection getConnection()throws Exception{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433; DatabaseName=ecology80";
return DriverManager.getConnection(url, "sa", "1");
}
public static void close(ResultSet rs,Statement sta,Connection con)throws Exception{
if(rs!=null){
//关闭结果集
rs.close();
}
if(sta!=null){
//关闭操作句柄
sta.close();
}
if(con!=null){
//关闭链接
con.close();
}
}
}
新人刚学不久,求教怎么加个方法验证是否连接成功啊
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Basehrm {
public static Connection getConnection()throws Exception{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url="jdbc:sqlserver://localhost:1433; DatabaseName=ecology80";
return DriverManager.getConnection(url, "sa", "1");
}
public static void close(ResultSet rs,Statement sta,Connection con)throws Exception{
if(rs!=null){
//关闭结果集
rs.close();
}
if(sta!=null){
//关闭操作句柄
sta.close();
}
if(con!=null){
//关闭链接
con.close();
}
}
}
新人刚学不久,求教怎么加个方法验证是否连接成功啊
public static Connection getConnection(String url,
String user,
String password)
throws SQLException试图建立到给定数据库 URL 的连接。DriverManager 试图从已注册的 JDBC 驱动程序集中选择一个适当的驱动程序。 参数:
url - jdbc:subprotocol:subname 形式的数据库 url
user - 数据库用户,连接是为该用户建立的
password - 用户的密码
返回:
到 URL 的连接
抛出:
SQLException - 如果发生数据库访问错误
return conn!=null;
}
package DataBase;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DatabaseDemo3 { public static void main(String[] args) {
// TODO Auto-generated method stub
Connection conn = null;
Statement stat = null;
String url ="jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=utf-8&useSSL=false";
String sql = "UPDATE USERS SET USER_QQ='112549966' WHERE USER_SEX='WOMAN'";
try{
Class.forName("com.mysql.jdbc.Driver"); //加载JDBC
System.out.println("JDBC加载成功!!");
} catch(Exception e){
System.out.println("JDBC加载失败!");
e.printStackTrace();
}
try{
conn = DriverManager.getConnection(url,"root","123456");
System.out.println("数据库连接成功!");
stat = conn.createStatement();
stat.executeUpdate(sql);
System.out.println("数据修改成功!");
} catch(SQLException e){
System.out.println("数据修改失败!");
e.printStackTrace();
}
finally{
try{
conn.close();
System.out.println("MySQL数据库已关闭!");
} catch(SQLException e){
System.out.println("MySQL数据库关闭失败!");
e.printStackTrace();
}
}
}
}
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
public List<Teacher> cx(){
List<Teacher> list=new ArrayList<Teacher>();
try {
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/你数据库的项目名";
String user="root";//数据库用户
String pwd="123";//数据库密码
conn = DriverManager.getConnection(url,user,pwd);
ps = conn.prepareStatement(" select id,name,pwd from teacher ");
rs= ps.executeQuery();
while(rs.next()){
Teacher t=new Teacher();
t.setId(rs.getInt("id"));
t.setName(rs.getString("name"));
t.setPwd(rs.getInt("pwd"));
list.add(t);
t = null;
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}