<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>添加新数据后的数据显示</title>
</head>
<body><div align="center">插入后的数据库为:</div>
<%
String in_xuehao=request.getParameter("insert_xuehao");
if(in_xuehao==null) {in_xuehao=""; }
byte b[]=in_xuehao.getBytes("ISO-8859-1");
in_xuehao=new String(b);
String in_name=request.getParameter("insert_name");
if(in_name==null) {in_name=""; }
String in_sex=request.getParameter("insert_sex");
if(in_sex==null) {in_sex=""; }
String in_age=request.getParameter("insert_age");
if(in_age==null) {in_age=""; }
String in_jiguan=request.getParameter("insert_jiguan");
if(in_jiguan==null) {in_jiguan=""; }
String in_dept=request.getParameter("insert_dept");
if(in_dept==null) {in_dept=""; }
Connection con=null;
Statement sql=null;
ResultSet rs=null;
String xuehao,name,sex,jiguan,dept;
int age;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("mmm"+e);}
try {con=DriverManager.getConnection("jdbc:odbc:university","" ,"");
sql=con.createStatement();String condition1=
"Insert INTO student(Xuehao,Name,Sex,Age,Jiguan,Dept) VALUES("+"'"+in_xuehao+"','"+in_name+"',"+in_sex+",'"+in_age+"','"+in_jiguan+"','"+in_dept+"'"+")" ;
//执行更新操作:
sql.executeUpdate(condition1);Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("abb"+e+"bb");}try{ con=DriverManager.getConnection("jdbc:odbc:university","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
out.print("<Table Border=1 align=center>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄");
out.print("<TH width=50>"+"籍贯");
out.print("<TH width=50>"+"部门");
out.print("<TH width=50>"+"更改");
out.print("<TH width=50>"+"删除");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
xuehao=rs.getString("Xuehao");
out.print("<TD >"+xuehao+"</TD>");
name=rs.getString("Name");
out.print("<TD >"+name+"</TD>");
sex=rs.getString("Sex");
out.print("<TD >"+sex+"</TD>");
age=rs.getInt("Age");
out.print("<TD >"+age+"</TD>");
jiguan=rs.getString("Jiguan");
out.print("<TD >"+jiguan+"</TD>");
dept=rs.getString("Dept");
out.print("<TD >"+dept+"</TD>");
out.print("<TD >"+"<a href=Change.jsp>"+"修改"+"</a>"+"</TD>");
out.print("<TD >"+"<a href=Del.jsp>"+"删除"+"</a>"+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
out.print("<div align=center>"+"<a href=Insert.jsp>"+"添加新的记录"+"</a>"+"</div>");
con.close();}
catch(SQLException e) {out.print("aaaa"+e+"aaaa"); }
finally{
} %></body>
</html>出错地方:<%出错原因:insert "finally" to complete TryStatement
<%@ page import="java.sql.*" %><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>添加新数据后的数据显示</title>
</head>
<body><div align="center">插入后的数据库为:</div>
<%
String in_xuehao=request.getParameter("insert_xuehao");
if(in_xuehao==null) {in_xuehao=""; }
byte b[]=in_xuehao.getBytes("ISO-8859-1");
in_xuehao=new String(b);
String in_name=request.getParameter("insert_name");
if(in_name==null) {in_name=""; }
String in_sex=request.getParameter("insert_sex");
if(in_sex==null) {in_sex=""; }
String in_age=request.getParameter("insert_age");
if(in_age==null) {in_age=""; }
String in_jiguan=request.getParameter("insert_jiguan");
if(in_jiguan==null) {in_jiguan=""; }
String in_dept=request.getParameter("insert_dept");
if(in_dept==null) {in_dept=""; }
Connection con=null;
Statement sql=null;
ResultSet rs=null;
String xuehao,name,sex,jiguan,dept;
int age;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("mmm"+e);}
try {con=DriverManager.getConnection("jdbc:odbc:university","" ,"");
sql=con.createStatement();String condition1=
"Insert INTO student(Xuehao,Name,Sex,Age,Jiguan,Dept) VALUES("+"'"+in_xuehao+"','"+in_name+"',"+in_sex+",'"+in_age+"','"+in_jiguan+"','"+in_dept+"'"+")" ;
//执行更新操作:
sql.executeUpdate(condition1);Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("abb"+e+"bb");}try{ con=DriverManager.getConnection("jdbc:odbc:university","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
out.print("<Table Border=1 align=center>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄");
out.print("<TH width=50>"+"籍贯");
out.print("<TH width=50>"+"部门");
out.print("<TH width=50>"+"更改");
out.print("<TH width=50>"+"删除");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
xuehao=rs.getString("Xuehao");
out.print("<TD >"+xuehao+"</TD>");
name=rs.getString("Name");
out.print("<TD >"+name+"</TD>");
sex=rs.getString("Sex");
out.print("<TD >"+sex+"</TD>");
age=rs.getInt("Age");
out.print("<TD >"+age+"</TD>");
jiguan=rs.getString("Jiguan");
out.print("<TD >"+jiguan+"</TD>");
dept=rs.getString("Dept");
out.print("<TD >"+dept+"</TD>");
out.print("<TD >"+"<a href=Change.jsp>"+"修改"+"</a>"+"</TD>");
out.print("<TD >"+"<a href=Del.jsp>"+"删除"+"</a>"+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
out.print("<div align=center>"+"<a href=Insert.jsp>"+"添加新的记录"+"</a>"+"</div>");
con.close();}
catch(SQLException e) {out.print("aaaa"+e+"aaaa"); }
finally{
} %></body>
</html>出错地方:<%出错原因:insert "finally" to complete TryStatement
解决方案 »
- 急求:Invalid user settings C:\Documents and Settings\administrator\.m2\settings.xml
- ssh中如何在上传的图片上生产水印
- jsp页面乱码,怎么解决呢?? 字段是“7mm”可在表格里显示“7!”,有的还是"?"
- 请教一个EXCEL报表处理的问题
- 这个判断条件是什么作用?
- 如何获取需要用户认证的url内容------急急急!!!
- unix c 程序员如何最快学习jsp?
- 关于下拉框的问题,有点难度!请各位大虾帮我看看!
- 如何去掉frameset中的frame之间的分隔线
- java怎么给用户上传图片到数据库
- {附有代码}保存session后,不关闭此页面,然后重新打开同一个页面,保存的session为空是什么原因?
- JSP注册数据写入SQLserver2005报错,
仔细看下。你一有个嵌套的try块没有catch.
try {con=DriverManager.getConnection("jdbc:odbc:university","" ,"");
sql=con.createStatement();String condition1=
"Insert INTO student(Xuehao,Name,Sex,Age,Jiguan,Dept) VALUES("+"'"+in_xuehao+"','"+in_name+"',"+in_sex+",'"+in_age+"','"+in_jiguan+"','"+in_dept+"'"+")" ;
//执行更新操作:
sql.executeUpdate(condition1);Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("abb"+e+"bb");}
Connection con=null;
Statement sql=null;
ResultSet rs=null;
这三个变量 申明了两次
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=ISO-8859-1">
<title>添加新数据后的数据显示</title>
</head>
<body> <div align="center">
插入后的数据库为:
</div>
<%
String in_xuehao=request.getParameter("insert_xuehao");
if(in_xuehao==null) {
in_xuehao="";
}
byte b[]=in_xuehao.getBytes("ISO-8859-1");
in_xuehao=new String(b);
String in_name=request.getParameter("insert_name");
if(in_name==null) {
in_name="";
}
String in_sex=request.getParameter("insert_sex");
if(in_sex==null) {
in_sex="";
}
String in_age=request.getParameter("insert_age");
if(in_age==null) {
in_age="";
}
String in_jiguan=request.getParameter("insert_jiguan");
if(in_jiguan==null) {
in_jiguan="";
}
String in_dept=request.getParameter("insert_dept");
if(in_dept==null) {
in_dept="";
}
Connection con=null;
Statement sql=null;
ResultSet rs=null;
String xuehao,name,sex,jiguan,dept;
int age;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
out.print("mmm"+e);
}
try {
con=DriverManager.getConnection("jdbc:odbc:university","" ,"");
sql=con.createStatement();
String condition1=
"Insert INTO student(Xuehao,Name,Sex,Age,Jiguan,Dept) VALUES("+"'"+in_xuehao+"','"+in_name+"',"+in_sex+",'"+in_age+"','"+in_jiguan+"','"+in_dept+"'"+")" ;
//执行更新操作:
sql.executeUpdate(condition1);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(
ClassNotFoundException e){out.print("abb"+e+"bb");
}
try{
con=DriverManager.getConnection("jdbc:odbc:university","","");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM student");
out.print("<Table Border=1 align=center>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=100>"+"姓名");
out.print("<TH width=50>"+"性别");
out.print("<TH width=50>"+"年龄");
out.print("<TH width=50>"+"籍贯");
out.print("<TH width=50>"+"部门");
out.print("<TH width=50>"+"更改");
out.print("<TH width=50>"+"删除");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
xuehao=rs.getString("Xuehao");
out.print("<TD >"+xuehao+"</TD>");
name=rs.getString("Name");
out.print("<TD >"+name+"</TD>");
sex=rs.getString("Sex");
out.print("<TD >"+sex+"</TD>");
age=rs.getInt("Age");
out.print("<TD >"+age+"</TD>");
jiguan=rs.getString("Jiguan");
out.print("<TD >"+jiguan+"</TD>");
dept=rs.getString("Dept");
out.print("<TD >"+dept+"</TD>");
out.print("<TD >"+"<a href=Change.jsp>"+"修改"+"</a>"+"</TD>");
out.print("<TD >"+"<a href=Del.jsp>"+"删除"+"</a>"+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
out.print("<div align=center>"+"<a href=Insert.jsp>"+"添加新的记录"+"</a>"+"</div>");
con.close();
}catch(SQLException e) {
out.print("aaaa"+e+"aaaa");
}
}catch(Exception e){
}finally{
}
%>
</body>
</html>