Document : Updatemysql
Created on : 2016-6-4, 10:01:31
Author : zhanghuiqing
--%>
JSP PageConnection con;
Statement st;
ResultSet rs;
%>
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mytest","root","");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from course");
}
catch(Exception e){
e.printStackTrace();
}
%>
课程号 | 课程名 | 教师号 |
try{
int count=st.executeUpdate("Update course set cname='Servlet' where cno='1017'");
if(count!=0){
System.out.print("影响行数"+count);
rs=st.executeQuery("select * from course");
}
}
catch(Exception e){
e.printStackTrace();
}
%>
更新后的记录
课程号 | 课程名 | 教师号 |
rs.close();
st.close();
con.close();
%>