Question

用java实现 sql数据库操作代码代码

Answer 1

常见的java需要通过两种驱动来实现

odbc jdbc，所以你可以在这里查找

odbc:
package smxc;

import java.sql.*;

public class Sql_conn {

public static void main(String[] args) {

String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=smxc"; //smxc数据库名称

String userName = "sa";

String userPwd = "sa";

Connection Sql_conn ;

try {

Class.forName(driverName);

Sql_conn = DriverManager.getConnection(dbURL, userName, userPwd);

System.out.println("Connection Successful!");

}

catch (Exception e) {

e.printStackTrace();

}

}

}