一. JDBC
要用到的类:
1. Connection
2. DriverManager
3. Statement
4. PreparedStatement
5. Results
二.创建一个JDBC驱动:
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
三.数据库的连接:
Connection conn=DriverManager.getConnection("url","userName","userPass");
URL:jdbc:sqlserver://localhost:1433;databaserName=db_net;
四.执行语句:
Statement stmt=conn.createStatement();
stmt.executeUpdate("insert into tb_usertable values('zhoufei','123');");
stmt.executeUpdate("insert into tb_usertable values('zhoufei','123');");