
复制public class TestMysqlConn { publicstatic void main(String[] args) { Connection con; Statement stmt; ResultSet rs; try { //1,关于装载数据库驱动程序 Class.forName("com.mysql.jdbc.Driver").newInstance(); //2,数据建立数据库连接 con = DriverManager.getConnection("jdbc:mysql://3xmq.com:3306/test",库连"root","root"); //3,IT技术网创建数据库操作对象 stmt = con.createStatement(); //4,接池简教执行sql语句 rs = stmt.executeQuery("select * from _test"); //5,香港云服务器关于处理返回结果集 while(rs.next()){ int num = rs.getInt("id"); String name = rs.getString("name"); String des = rs.getString("description"); System.out.println(num + " " + name + " " + des); } //6,数据库连断开数据库连接 stmt.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); System.out.println("连接失败"); } } } 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.站群服务器