Question

用java编写一个连接数据库的程序。急需！！！谢谢

Answer 1

String url = "com.mysql.jdbc.Driver";
String driver = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "12345";

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

try {
Class.forName(driver); // 1.注册驱动
conn = DriverManager.getConnection(url, user, password); // 获取数据库连接
stmt = conn.createStatement(); // 获取数据库操作对象
rs = stmt.executeQuery("要执行的SQL语句"); // 执行SQL返回结果集
while (rs.next()) { // 逐条记录进行访问
Object obj = rs.getObject(1); // 获取一条记录的第一列
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
// 资源释放
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}

Answer 2

package com.cj.tc10;

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

public class DBuser {

public void DBtest() {
Connection conn = null;

try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("数据库驱动加载成功");

conn = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;DatabaseName数据库名", "sa", "密码");
System.out.println("数据库连接成功");
}
catch(ClassNotFoundException e){
e.printStackTrace();
System.out.println("数据库驱动加载未成功");
} catch (SQLException e) {

System.out.println("数据库连接未成功");
e.printStackTrace();
}

}

}

Answer 3

参考JDBC啊...