简单使用案例:
public class jdbctest {
public static void main(String[] args) throws ClassNotFoundException, SQLException
{
//加载驱动程序,需要先关联到项目中
Class.forName("com.mysql.jdbc.Driver");
//这个url的结构是jdbc:mysql://主机名:端口/数据库名
String url = "jdbc:mysql://localhost:3306/breezetest";
String user = "root";
String password = "openacs";
//使用DriverManager获得一个Connection
Connection conn = DriverManager.getConnection(url, user, password);
//用Connection获得一个Statement
Statement statement = conn.createStatement();
//用Statement来执行数据库语句。
statement.execute("insert into testtable(name,password) values('belinda','openacs')");
statement.execute("update testtable set password='acs' where name='belinda'");
//查询结果放大ResultSet中
ResultSet rs = statement.executeQuery("select * from testtable");
while(rs.next())
{
System.out.println("name: "+rs.getString(1));
System.out.println("password: "+ rs.getString(2));
}
}
}