package test1;
import java.sql.*;
public class Demo {
public static void main(String []args){
PreparedStatement ps=null;
Connection ct=null;
ResultSet rs=null;
try {
//1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//2.得到连接[指定连接到哪个数据源,用户名,密码]
ct=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=stdb1","sa","hyj84884824");
//3.创建PrepareStatement 用处是:主要用于发送sql语句
// ps=ct.prepareStatement("create table dept2(deptno int not null ,dname varchar(10) ,loc varchar(10),primary key(deptno))");
// ps=ct.prepareStatement("insert into dept values ('2','qwe','QWE')");
ps=ct.prepareStatement("select *from dept ");
//4.执行(crud,创建数据库,备份数据库,删除数据库....)
//executeUpdate可以执行增加、删除和修改
// ps.executeUpdate();
rs=ps.executeQuery();
while(rs.next()){
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
rs.close();
if(ps!=null){
ps.close();
}
if(ct!=null){
ct.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
jdbc连接数据库
最新推荐文章于 2024-02-21 11:19:36 发布