package DML1ForMySql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//基本的插入 更新操作
public class TestDml1 {
public static void main(String[] args) {
String className = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/test";
String user = "root";
String password = "1234";
Connection mySqlconn=null;
PreparedStatement ps = null;
ResultSet rs = null;
Statement st = null;
try{
Class.forName(className).newInstance();
mySqlconn= DriverManager.getConnection(url, user, password);
if(mySqlconn.isClosed()== false)
{
System.out.println("MySql已连接");
}
//更新一条记录
ps = mySqlconn.prepareStatement("update student set Name = ? where ID = ?");
ps.setString(1, "吴财");
ps.setInt(2, 1);
ps.executeUpdate();
//插入一条记录
ps = mySqlconn.prepareStatement("insert into student values(?,?)");
ps.setString(1, "谢峥");
ps.setInt(2, 2);
ps.executeUpdate();
st = mySqlconn.createStatement();
ps = mySqlconn.prepareStatement("");
rs = ps.executeQuery("select * from student");
while(rs.next())
{
String rss = rs.getString("Name");
System.out.println(rss);
}
}catch(ClassNotFoundException e){
e.printStackTrace();
System.out.println("ClassNotFoundException");
}catch(SQLException ee){
ee.printStackTrace();
}catch( InstantiationException eee){
eee.printStackTrace();
}catch(IllegalAccessException eeee){
eeee.printStackTrace();
}finally{
try{
//关闭各个连接 后打开的先关闭
if(rs != null){
rs.close();
rs = null;//关闭后设置为空 让垃圾收集器收集回去 节省资源
}
if(ps != null){
ps.close();
ps = null;//关闭后设置为空 让垃圾收集器收集回去 节省资源
}
if(mySqlconn != null){
mySqlconn.close();
if(mySqlconn.isClosed()== true)
{
System.out.println("MySql的连接已经关闭");
}
mySqlconn = null;//关闭后设置为空 让垃圾收集器收集回去 节省资源
}
}catch(SQLException e){
e.printStackTrace();//所有catch到的Exception以后都需要用log4j记录!
}
}
}
}