本文共 1058 字,大约阅读时间需要 3 分钟。
package cn.sigangjun.project;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;/** * @author sigangjun * */public class MysqlJdbcTest { public static void main(String[] args) throws SQLException, InstantiationException, IllegalAccessException, ClassNotFoundException { //1.注册驱动 DriverManager.registerDriver(new com.mysql.jdbc.Driver()); System.getProperty("jdbc.drivers","com.mysql.jdbc.Driver:oracle.jdbc.driver.OracleDriver"); Class.forName("com.mysql.jdbc.Driver").newInstance(); //2.建立连接 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dang","root","root"); //3.创建语句 Statement st = con.createStatement(); //4.执行语句 ResultSet rs = st.executeQuery("select * from d_user"); //5.执行结果 while(rs.next()){ System.out.print(rs.getObject(1)+"\t"); System.out.print(rs.getObject(2)+"\t"); System.out.print(rs.getObject(3)+"\t"); System.out.println(rs.getObject(4)); } //6.释放资源 rs.close(); st.close(); con.close(); }}
转载地址:http://csnni.baihongyu.com/