Java连接数据库

转载

mb5ff981d806017 2021-09-25 09:56:00

文章标签 sql java 数据库 ide 驱动程序 文章分类 Java 后端开发

Java与sql sever的连接

先放代码

import java.sql.*;

public class forsql {
    public static void main(String[] args) throws SQLException {
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            //1.加载sqlsever驱动
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            //2.通过DriverManager获取数据库连接
            String url = "jdbc:sqlserver://localhost:1433;DatabaseName=java";
            String username = "sa";
            String password = "123456";
            conn = DriverManager.getConnection(url, username, password);
            //3.通过connection对象获取Statement对象
            stmt = conn.createStatement();
            //4.使用Statement执行SQL语句
            String sql1 = "delete FROM datam where ID>6;";//删除操作
            String sql = "select * from dbo.datam";
            rs = stmt.executeQuery(sql1 + sql);
            //5.操作ResultSet结果集
            System.out.println("ID   Name   Sex   Age");
            while (rs.next()) {
                //id(char),name(char),sex(char),age(int)
                String id = rs.getString("ID");
                String name = rs.getString("Name");
                String sex = rs.getString("Sex");
                int age = rs.getInt("Age");
                System.out.println(id + "    " + name + "    " + sex + "    " + age);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                rs.close();
            }
            if (stmt != null) {
                stmt.close();
            }
            if (conn != null) {
                conn.close();
            }
        }
    }
}