Java连接数据库的标准方式

来源：互联网发布：php文件分享系统编辑：程序博客网时间：2024/04/30 02:45

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQL {

    public static void main(String[] args) {
        String dirverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 加载JDBC驱动
        String URL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sic_itemSystem";//DatabaseName=sic_itemSystem数据库名称可以写错误了,要与你数据里看到的一个样子
        String SqlUsername = "sa";
        String SqlPwd = "sa";

        Connection conn = null;
        Statement stmt = null;
        ResultSet rset = null;

        String pd = null;
        try {
            Class.forName(dirverName);
            conn = DriverManager.getConnection(URL, SqlUsername, SqlPwd);
            stmt = conn.createStatement();
            rset = stmt.executeQuery("SELECT * FROM user");
            while (rset.next()) {
                pd = rset.getString("userName");
                System.out.println(pd);
            }
        } catch (ClassNotFoundException e1) {
            e1.printStackTrace();
        } catch (SQLException e2) {
            e2.printStackTrace();
        } catch (Exception e3) {
            e3.printStackTrace();
        } finally {
            try {
                conn.close();
                stmt.close();
                rset.close();
            } catch (SQLException e) {

            }
        }
    }
}