jdbc连接数据库

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 blocke.printStackTrace();}finally{try {rs.close();if(ps!=null){ps.close();}if(ct!=null){ct.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}