网页访问数据库

最新推荐文章于 2022-11-13 23:17:40 发布

yaomenglan69

最新推荐文章于 2022-11-13 23:17:40 发布

阅读量678

点赞数

文章标签： jdbc sqlserver microsoft string 数据库 url

本文链接：https://blog.csdn.net/yaomenglan69/article/details/6477831

版权

try {
   Class.forName(JDBC驱动类);
} catch (ClassNotFoundException e) {
   System.out.println("无法找到驱动类");
}
try {
   Connection con=DriverManager.getConnection(JDBC URL,数据库用户名,密码);

   Statement stmt = con.createStatement();
   ResultSet rs = stmt.executeQuery("SELECT a, b, c FROM Table1");

   while (rs.next()) {
         int x = rs.getInt("a");
         String s = rs.getString("b");
         float f = rs.getFloat("c");
   }
   con.close();
} catch (SQLException e) {
   e.printStackTrace();
}

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con =DriverManager.getConnection("jdbc:odbc:news","sa","sa")

String URL="jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=news";

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con = DriverManager.getConnection(URL,"sa","sa");