数据库,java怎么连接sqlserver数据库

发布网友发布时间：2022-04-30 20:05

共1个回答

热心网友时间：2022-04-09 19:14

记得jar包：mysql-connector-java-5.0.7.jar

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class DBHelper {

public static final String url = "jdbc:mysql://127.0.0.1/student";

public static final String name = "com.mysql.jdbc.Driver";

public static final String user = "root";

public static final String password = "root";

public Connection conn = null;

public PreparedStatement pst = null;

public DBHelper(String sql) {

try {

Class.forName(name);//指定连接类型

conn = DriverManager.getConnection(url, user, password);//获取连接

pst = conn.prepareStatement(sql);//准备执行语句

} catch (Exception e) {

e.printStackTrace();

}

//关闭连接

public void close() {

try {

this.conn.close();

this.pst.close();

} catch (SQLException e) {

e.printStackTrace();

}