JDBC

1使用jdbc步骤
  a.导入数据库厂商提供的驱动程序(导入jar包)
  b.加载驱动程序
  Class.forName("驱动程序类");
  c.获得连接
  Connection conn =DriverManager.getConnection(url,username,password);
  url = "jdbc:数据库://ip地址:端口;数据库";
  username="用户名";
  password="密码";
  d.获得执行sql对象,执行sql返回结果
  Statement stat = conn.createStatement();
  ResultSet rs = stat.executeQuery("sql语句");
  e.处理结果集
  while(rs.next()){
  Xxxx s = rs.getXxxx("字段名|数字");
  }
  注意数据下标从1开始
  f.释放资源
  rs.close();
  stat.close();
  conn.close();
public class Test1 {
    private static Logger logger = Logger.getLogger(Test1.class.getName());
    public static void main(String[] args) {
        Connection conn = null;
        //1.加载驱动
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        } catch (ClassNotFoundException e) {
            logger.error(e);
        }
        //2.建立连接
        try{
        conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=epet","sa","sa");
        System.out.println("建立连接成功");
        }catch(SQLException e){
            logger.error(e);
        }finally{
            //3.关闭连接
            try{
                if(null!= conn){
                    conn.close();
                    System.out.println("关闭连接成功");
                }
            }catch(SQLException e){
                    logger.error(e);
        }
        
    }
    
    }
}


public class Test2 {

    public static void main(String[] args) {
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String url = "jdbc:sqlserver://localhost:1433;databaseName = schoolDB";
            String username = "sa";
            String password = "sa";
            int deptno = 200;
            String dname = "ww";
            String loc = "dd";
            Connection conn =DriverManager.getConnection(url,username,password);
            Statement stat = conn.createStatement();
//增加        String sql = "insert into DEPT(DEPTNO,dname,LOC)values(800,'szb','yiyang')";
//修改        String sql1 = "update DEPT set dname ='szb7' where DEPTNO = 800";
//删除        String sql2="delete from dept where deptno=800";    
            String sql3= "insert into DEPT(DEPTNO,dname,LOC)values(?,?,?)";
            PreparedStatement pst = conn.prepareStatement(sql3);
            pst.setInt(1, deptno);
            pst.setString(2, dname);
            pst.setString(3, loc);
            pst.executeUpdate();
//            stat.executeUpdate(sql3);
            stat.close();
            conn.close();
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }catch(SQLException e){
            e.printStackTrace();
        }
        
    }

}

 

 

 

posted @ 2017-05-07 19:27  孤独患者xy  阅读(120)  评论(0编辑  收藏  举报