1.查询语句
<%
String url="jdbc:odbc:happy";
String user="sa";
String pw="root";
Connection con=DriverManager.getConnection(url, user,pw);
Statement st=con.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql="select * from info";
ResultSet rs=st.executeQuery(sql);
rs.last();
%>
<br> <br> <br> <br> <br>
你要查询的学生数据表共有:
<font size="5" color="red"><%=rs.getRow() %> </font>人
<table border="2" bgcolor="ccceee" width="600">
<tr>
<th>记录条数</th>
<th>学号</th>
<th>姓名</th>
<th>性别</th>
<th>年龄</th>
<th>体重</th>
</tr>
<%rs.beforeFirst();
while(rs.next()){
%>
<tr align="center">
<td><%=rs.getRow()%></td>
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
</tr>
<%
}
rs.close();
st.close();
con.close();
%>
2删除语句
<%
String url="jdbc:odbc:happy";
String user="sa";
String pw="root";
Connection con=DriverManager.getConnection(url, user,pw);
Statement stmt =con.createStatement();
String id=request.getParameter("id");
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b,"utf-8");
String sql="delete from info where id="+id;
stmt.executeUpdate(sql); %>
<center>
<h2>删除学生信息</h2>
<p>该学生记录已经被删除!</p>
3插入语句
<%
String id=request.getParameter("id");
byte b[]=id.getBytes("ISO-8859-1");//把上页获得的数据(默认是ISO-8859-1)转换成utf_8形势
id=new String(b,"utf-8");
String name=request.getParameter("name");
byte b1[]=name.getBytes("ISO-8859-1");
name=new String(b1,"utf-8");
String sex=request.getParameter("sex");
byte b2[]=sex.getBytes("ISO-8859-1");
sex=new String(b2,"utf-8");
String age=request.getParameter("age");
byte b3[]=age.getBytes("ISO-8859-1");
age=new String(b3,"utf-8");
String tizhong=request.getParameter("tizhong");
byte b4[]=tizhong.getBytes("ISO-8859-1");//防止乱码
tizhong=new String(b4,"utf-8");
String url="jdbc:odbc:happy";
String user="sa";
String pw="root";
Connection con=DriverManager.getConnection(url, user,pw);
Statement st=con.createStatement();
String sql="insert into info values('"+id+"','"+name+"','"+sex+"','"+age+"','"+tizhong+"')";
st.executeUpdate(sql);
st.close();
con.close();
%>
4修改语句
<%
String id=request.getParameter("id");
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b,"utf-8");
String name=request.getParameter("name");
byte b1[]=name.getBytes("ISO-8859-1");
name=new String(b1,"utf-8");
String sex=request.getParameter("sex");
byte b2[]=sex.getBytes("ISO-8859-1");
sex=new String(b2,"utf-8");
String age=request.getParameter("age");
byte b3[]=age.getBytes("ISO-8859-1");
age=new String(b3,"utf-8");
String tizhong=request.getParameter("tizhong");
byte b4[]=tizhong.getBytes("ISO-8859-1");
tizhong=new String(b4,"utf-8");
String url="jdbc:odbc:happy";
String user="sa";
String pw="root";
Connection con=DriverManager.getConnection(url, user,pw);
Statement st=con.createStatement();
String sql1="UPDATE info SET name = "+"'"+name+"'"+" WHERE id="+"'"+id+"'";
String sql2="UPDATE info SET sex = "+"'"+sex+"'"+" WHERE id="+"'"+id+"'";
String sql3="UPDATE info SET age = "+"'"+age+"'"+" WHERE id="+"'"+id+"'";
String sql4="UPDATE info SET tizhong = "+"'"+tizhong+"'"+" WHERE id="+"'"+id+"'";
st.executeUpdate(sql1);
st.executeUpdate(sql2);
st.executeUpdate(sql3);
st.executeUpdate(sql4);
st.close();
con.close();
%>