代码示例:
import java.sql.*;
public class pro {
public static void main(String[] args) {
Connection con=null;
PreparedStatement pst=null;
Statement st=null;
ResultSet rs=null;
try{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/myfirstdb","root","2490248");
//preparedStatement的使用
pst=con.prepareStatement("insert into dept values(?,?,?)");
//pst=con.prepareStatement("update dept set dname=? where did=?");
//pst=con.prepareStatement("select * from dept where did=?");
pst.setInt(1,10);
pst.setString(2,"王大妈子!");
pst.setString(3,"hello");
try{
pst.executeUpdate();
System.out.println("插入成功!");
}catch(SQLException e){
System.out.println("插入失败!");
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
if(rs!=null){
rs.close();
rs=null;
}
}catch(SQLException e){
e.printStackTrace();
}
}
}
}