面部疖肿图片:JSP在线考试判卷问题

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/09 03:30:51
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String driver = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=cx";
Connection conn = DriverManager.getConnection(driver,"sa","sa");
String sql="select * from userinformation where uid='"+uid+"'";
PreparedStatement ps=null;
ResultSet rs=null;
int i;
int score=0;//总分
String selectvalue;
String id;

for (i=1;i<=20;i++)
{
selectvalue=request.getParameter("select"+i);
id=request.getParameter("h"+i);
ps=conn.prepareStatement("select * from xuanzeti where id=? and daan=?");
ps.setInt(1,Integer.parseInt(id));
ps.setString(2,selectvalue);
rs=ps.executeQuery();
if (rs.next())
{
score=score+1;
}

System.out.println(id+":"+selectvalue+":"+score);
}
score=score*5;
ps=conn.prepareStatement("select * from userscore where uid=?");
ps.setInt(1,Integer.parseInt(uid));
rs=ps.executeQuery();
rs.next();
ps=conn.prepareStatement("insert into userscore (uid,score) values (?,?)");
ps.setInt(1,Integer.parseInt(uid));
ps.setInt(2,score);
ps.executeUpdate();

%>

ps.setInt(1,Integer.parseInt(uid));这句话什么意思啊
我不想转换类型 uid原来是char 现在还想是char 应该怎么写啊~~~帮帮忙~~

ps.setString(1,new String(uid));就可以了。