import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class PrepareStatementTest {
public static void main(String[] args) throws Exception{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
Connection cnn = DriverManager.getConnection(url,"root","123");
String sql = "insert user values(null,?,'123@163.com','123')";
String sql2 = "select * from user";
try
(
PreparedStatement pst = cnn.prepareStatement(sql);
PreparedStatement pst2 = cnn.prepareStatement(sql2);
)
{
pst.setString(1, "xiaowang");
pst.executeUpdate();
ResultSet rs = pst2.executeQuery();
while(rs.next())
{
System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"
+rs.getString(3)+"\t"+rs.getString(4));
}
}
}
}