JavaSE学习笔记之JDBC连接步骤

来源：互联网发布：小学考试软件编辑：程序博客网时间：2024/04/29 18:45

下面我们以连接SQLServer2005为例说一下JDBC连接步骤

1.加载驱动

Class.forName(DRIVER);

2.创建连接

Connection ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=test","sa","111111");

3.执行sql语句

PreparedStatement  ps=ct.prepareStatement(sql);

4.将数据存入结果集

ResultSet rs=ps.executeQuery();

下面我们看一下完整的代码

import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.PreparedStatement;import java.sql.ResultSet;  import java.sql.SQLException;  import java.sql.Statement;  import java.util.Scanner;public class ConnDB {private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";private String sql = "select * from users";  public Connection getConn() {    try {    Class.forName(DRIVER);    Connection ct=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;databaseName=test","sa","111111");    PreparedStatement ps=ct.prepareStatement(sql);    ResultSet rs=ps.executeQuery();    while(rs.next()) {    //rs.getString(1)中的1代表取得sql表中第一列数据    System.out.println(rs.getString(1));    }   } catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}    return ct; } public static void main(String[] args) { ConnDB conndb = new ConnDB(); conndb.getConn(); }}