jdbc链接sqlserver数据库执行SQL脚本样例

来源：互联网发布：大神小的知错了编辑：程序博客网时间：2024/06/15 06:31

public static void main(String[] args){
       String dr = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
       String URL = "jdbc:sqlserver://localhost:1433;databaseName=icare";
       String USERNAME = "admin";
       String PASSWORD = "icare";
       try {
            // 加载驱动
            Class.forName(dr);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }


        Connection conn = null;
        System.out.println("开始连接数据库");
        try{
            conn=(Connection) DriverManager.getConnection(URL, USERNAME, PASSWORD);

            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("select * from ledcode");
           while(rs.next()){
               for(int j = 1; j <= rs.getMetaData().getColumnCount(); j++){
                   System.out.print(rs.getString(j));
                   System.out.print("\t");
               }
               System.out.println();
            }



            conn.close();
        }catch(SQLException e){
            e.printStackTrace();
            System.out.println("数据库连接失败！");
            return;
        }
        System.out.println("数据库连接成功");
   }

0 0