先导入jar包,mysql-connector-java-5.1.31-bin.jar
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class jdbcUtil {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//创建连接对象
//("jdbc:mysql://localhost:3306/one","root","root")
//one为数据库名,第一个root为用户名,第二个为root密码
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/one","root","root");
//连接完数据库后查询出表中的数据
String sql = "select * from student";
//创建数据库语句执行对象
PreparedStatement pre = conn.prepareStatement(sql);
//使用PreparedStatement 对象的executeQuery();方法执行查询的sql语句
ResultSet rst = pre.executeQuery();
System.out.println("学号\t姓名\t性别");
while (rst.next()) {
System.out.println(rst.getString("stuNo")+"\t"+
rst.getString("name")+"\t"+rst.getString("sex"));
}
System.out.println("连接成功 ");
}
}
下面有改进后的源码以及数据库,http://download.csdn.net/download/hgjacky/10121851。将数据库的配置信息提取为properties文件