1.加载及注册JDBC驱动程序以及建立连接对象
Class.forName("com.mysql.jdbc.Driver"); //Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://localhost/database?user=root&password=your_password";
Connection con = DriverManager.getConnection(url);
或者
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/database";
String user=root;
String password=your_password;
Connection con = DriverManager.getConnection(url,user,password);
其中“:3306”可有可无
2. 建立SQL陈述式对象(Statement Object)
Statement stmt = con.createStatement();
3. 执行SQL语句
executeQuery()
String query = "select * from test";
ResultSet rs=stmt.executeQuery(query);
结果集ResultSet
while(rs.next())
{rs.getString(1);rs.getInt(2);}
executeUpdate()
String upd="insert into test (id,name) values(1001,xuzhaori)";
int con=stmt.executeUpdate(upd);
execute()
4. close()
rs.close();
stmt.close();
con.close();
注意:IDE中导入相应包以及程序中import相应包以及相应try/catch