连接MySQL数据库:
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url ="jdbc:mysql://localhost/DB?user=root&password=root&useUnicode=true&characterEncoding=utf-8" ;
//DB为你的数据库名
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from users";
ResultSet rs=stmt.executeQuery(sql)
连接 sql server数据库:
String url = "jdbc:microsoft:sqlserver://localhost:1433;DataBaseName=DB";
<span style="white-space:pre"> </span>String user="root";
<span style="white-space:pre"> </span>String pwd="root";
<span style="white-space:pre"> </span>Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
<span style="white-space:pre"> </span>Connection conn = DriverManager.getConnection(url,user,pwd);