import java.sql.*;
public class MyConnection {
/*
* 这是使用MySql数据库的一段代码,端口是3306
*/
public static void main(String[] args) throws SQLException {
// mysql的驱动程序类是com.mysql.jdbc.Driver
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
/*
* 创建与DB数据库的连接,这里是提供JDBC的URL,如果要存取中文,还要再指定参数useUnicode和characterEncoding
* 如jdbc
* :mysql://localhost:3306/RuankoQA?user=root&password=1234&userUnicode
* =true&characterEncoding=utf-8 一个connection对象代表一个数据库连接
* getConnection()方法也可以在参数上指定用户名与密码,如: String url =
* "jdbc:mysql://localhost:3306/RuankoQA"; String user = "root"; String
* password = "1234"; Connection conn =
* DriverManager.getConnection(url,user,password);
*/
Connection conn = DriverManager
.getConnection("jdbc:mysql://localhost:3306/RuankoQA?user=root&password=1234");
// 进行读写
if (!conn.isClosed()) {
System.out.print("欢迎访问MySql数据库!---------------\n");
Statement st = conn.createStatement();
// 查询数据库中admin表
ResultSet rs = st.executeQuery("select * from admin");
while (rs.next()) {
System.out.print(rs.getString(1) + "\t");
System.out.print(rs.getString(2) + "\t");
System.out.print(rs.getString(3) + "\t");
System.out.print(rs.getString(4) + "\t");
System.out.println(rs.getDate(5));
}
rs.close();
st.close();
}
// 关闭数据库
conn.close();
}
}