一个最基本的JDBC连接:
Connection conn = [color=violet]null[/color];
PreparedStatement pt = [color=violet]null[/color];
[color=violet]try[/color] {
Class.forName("[color=blue]com.mysql.jdbc.Driver[/color]");
conn = DriverManager
.getConnection("[color=blue]jdbc:mysql://localhost:3306/test?user=root&password=111111[/color]");
conn.setAutoCommit(false);
pt = conn.prepareStatement[color=blue]("insert into ming "+" values(?,?)");[/color]
pt.setString(1, " xvm03 ");
pt.setString(2, " 123 ");
pt.executeUpdate();
pt = null;
pt = conn.prepareStatement("insert into ming "+" values(?,?,?)");
//create table ming(name varchar(20),password varchar(20))
pt.setString(1, " xvm03 ");
pt.setInt(2, 12);
pt.executeUpdate();
System.out.println("!!!!!!commit1");
System.out.println("!!!!!!!!no commit");
conn.commit();
conn.close();
pt.close();
System.out.println("ss");
} [color=violet]catch[/color] (Exception E) {
E.printStackTrace();
try
{
conn.rollback();
System.out.println("======");
}
catch(Exception e)
{
e.printStackTrace();
}
} [color=violet]finally [/color]{
if (null != pt) {
pt.close();
}
if(null!=conn){
conn.close();
}
}
Connection conn = [color=violet]null[/color];
PreparedStatement pt = [color=violet]null[/color];
[color=violet]try[/color] {
Class.forName("[color=blue]com.mysql.jdbc.Driver[/color]");
conn = DriverManager
.getConnection("[color=blue]jdbc:mysql://localhost:3306/test?user=root&password=111111[/color]");
conn.setAutoCommit(false);
pt = conn.prepareStatement[color=blue]("insert into ming "+" values(?,?)");[/color]
pt.setString(1, " xvm03 ");
pt.setString(2, " 123 ");
pt.executeUpdate();
pt = null;
pt = conn.prepareStatement("insert into ming "+" values(?,?,?)");
//create table ming(name varchar(20),password varchar(20))
pt.setString(1, " xvm03 ");
pt.setInt(2, 12);
pt.executeUpdate();
System.out.println("!!!!!!commit1");
System.out.println("!!!!!!!!no commit");
conn.commit();
conn.close();
pt.close();
System.out.println("ss");
} [color=violet]catch[/color] (Exception E) {
E.printStackTrace();
try
{
conn.rollback();
System.out.println("======");
}
catch(Exception e)
{
e.printStackTrace();
}
} [color=violet]finally [/color]{
if (null != pt) {
pt.close();
}
if(null!=conn){
conn.close();
}
}