if(name!=null&&num!=null && m!=null && e!=null && p!=null)
{
out.print(name+"<br>");
out.print(num+"<br>");
out.print(m+"<br>");
out.print(e+"<br>");
out.print(p+"<br>");
edit();
out.print("添加成功");
}
out.print();都能被执行,但是edit()不能被执行
下面是edit的代码:
<%!
String name=null;
String num=null;
String m=null;
String e=null;
String p=null;
public void edit()
{
int number=Integer.parseInt(num);
float math=Float.parseFloat(m);
float english=Float.parseFloat(e);
float phics=Float.parseFloat(p);
Connection conn=null;
Statement stmt=null;
PreparedStatement pstmt=null;
String sql=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:zjm");
sql="insert into Student(name,number,math,english,phics) values(?,?,?,?,?)";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,name);
pstmt.setLong(2,number);
pstmt.setFloat(3,math);
pstmt.setFloat(4,english);
pstmt.setFloat(5,phics);
int i=pstmt.executeUpdate();
pstmt.close();
conn.close();
}
catch(Exception ee)
{
}
}
%>
{
out.print(name+"<br>");
out.print(num+"<br>");
out.print(m+"<br>");
out.print(e+"<br>");
out.print(p+"<br>");
edit();
out.print("添加成功");
}
out.print();都能被执行,但是edit()不能被执行
下面是edit的代码:
<%!
String name=null;
String num=null;
String m=null;
String e=null;
String p=null;
public void edit()
{
int number=Integer.parseInt(num);
float math=Float.parseFloat(m);
float english=Float.parseFloat(e);
float phics=Float.parseFloat(p);
Connection conn=null;
Statement stmt=null;
PreparedStatement pstmt=null;
String sql=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:zjm");
sql="insert into Student(name,number,math,english,phics) values(?,?,?,?,?)";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1,name);
pstmt.setLong(2,number);
pstmt.setFloat(3,math);
pstmt.setFloat(4,english);
pstmt.setFloat(5,phics);
int i=pstmt.executeUpdate();
pstmt.close();
conn.close();
}
catch(Exception ee)
{
}
}
%>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货