如题,网上随便找的代码。
导入mysql-connector-java-5.1.39-bin.jar。
具体方法,网上说的可行。“在要导入的java项目中新建一个文件夹(一般命名为lib),然后把下载的jar包放进去;选中项目然后右键–>Build Path–>Configure Build Path,点击Add JARs…”
可用以下代码访问
1 package p1; 2 import java.sql.*; 3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 import java.sql.SQLException; 6 import java.sql.Statement; 7 8 public class c1 { 9 10 public static void main(String[] args) { 11 // TODO Auto-generated method stub 12 String url = "jdbc:mysql://localhost:3306/d1?useSSL=false"; 13 String user = "root"; 14 String password = "njnu123456"; 15 16 String query;// = "SELECT VERSION()"; 17 query="select * from t1"; 18 19 try (Connection con = DriverManager.getConnection(url, user, password); 20 Statement st = con.createStatement(); 21 ResultSet rs = st.executeQuery(query)) { 22 23 while (rs.next()) { 24 25 System.out.println(rs.getString(1)+rs.getString(2)); 26 } 27 28 } catch (SQLException ex) { 29 30 System.out.println("hi"); 31 } 32 } 33 34 }
对于测试数据库,结果:
1zs
2ls
3ww