Java连接Mysql实例
import java.sql.Connection;import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBCTest {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/logicaldoc?useUnicode=true&characterEncoding=utf-8";
String user = "root";
String password = "mypassword";
try {
Class.forName(driver);
// 连续数据库
Connection conn = DriverManager.getConnection(url, user, password);
if (!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
// statement用来执行SQL语句
// Statement statement = conn.createStatement();
// ResultSet rs = statement.executeQuery(sql);
// 要执行的SQL语句
String sql = "select * from ld_document where ld_id = ?";
PreparedStatement prepareStatement = conn.prepareStatement(sql);
prepareStatement.setLong(1, 2);
ResultSet rs = prepareStatement.executeQuery();
String name = null;
while (rs.next()) {
name = rs.getString("ld_filename");
System.out.println(name);
}
rs.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
原文出处：http://www.zzt123.com/html/2012/0727/1343368532.html 可以把 jar包以及数据库的配置方式和发出来 现在很多用框架如hibernate, ibatis连数据库了。
页:
[1]