<%
request.setCharacterEncoding("gb2312");
OperatorManagerInfo netInfo = new OperatorManagerInfo();
String id=request.getParameter("id"); String operator=request.getParameter("operator");
String password=request.getParameter("password");
String isadmin=request.getParameter("isadmin");String name=request.getParameter("name");
String address=request.getParameter("address");
String tel=request.getParameter("tel");
String netindex=request.getParameter("netindex");
out.print(operator);
String strSql="insert into operatormanager(operator,pass,isadmin,name,tel,address,netindex) values( '"+operator+"','"+password+"',"+isadmin+",'"+name+"','"+tel+"','"+address+"','"+netindex+"')";
out.println("新用户注册成功!");
netInfo.InsertRecord(strSql);
// out.println(strSql);
%>
request.setCharacterEncoding("gb2312");
OperatorManagerInfo netInfo = new OperatorManagerInfo();
String id=request.getParameter("id"); String operator=request.getParameter("operator");
String password=request.getParameter("password");
String isadmin=request.getParameter("isadmin");String name=request.getParameter("name");
String address=request.getParameter("address");
String tel=request.getParameter("tel");
String netindex=request.getParameter("netindex");
out.print(operator);
String strSql="insert into operatormanager(operator,pass,isadmin,name,tel,address,netindex) values( '"+operator+"','"+password+"',"+isadmin+",'"+name+"','"+tel+"','"+address+"','"+netindex+"')";
out.println("新用户注册成功!");
netInfo.InsertRecord(strSql);
// out.println(strSql);
%>
解决方案 »
- Dtree使用的问题(getCheckedNodes调用出错)
- 关于access数据库连接问题,在线------急等
- The server encountered an internal error () that prevented it from fulfilling this request是什么错误
- 如何在填写某表单后同步生成数据库里面的数据
- 关于数据库中调用数据的问题
- 请问哪有开元的ERP或者OA之类的东西
- 急急急!!!我在Jsp(Java)中怎样返回存储过程的多个记录集??
- 求一个连接sql server2000的javabean(调试完成马上结贴) ----------------在线等待
- 刷新问题?
- 如何在JSP页面中选择路径
- 数据库执行(sql)放入变量中的值,再一条(sql)后怎么就看不到了呢?????
- 急求高手?bean中如何引用另一bean?
第二个为addview.jsp
这个我已经测试通过了的!
class="Net.OperatorManagerInfo 这个JAVABEAN我没有啊,数据库连接是写到这里的吗?
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class test
{
public static void main(String[] args)
{
//System.out.println("Test Java Program.");
Connection conn=null;
ResultSet rs=null;
Statement s=null;
String url="";
String driver=null;
String database="";
String uid="";
String pwd="";
String sql="";
DataSource ds=null;
Context ctx=null;
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
try
{
Class.forName(driver);
}
catch (ClassNotFoundException d)
{
System.out.println("Error at Classnotfoundexception "+d.getMessage());
}
url="jdbc:microsoft:sqlserver://YILIN:1433;DatabaseName=";
database="Domino-ZXwsj";
uid="sa";
pwd="sa";
sql="select * from tblfaomember";
url=url+database;
try
{
conn=DriverManager.getConnection(url);
System.out.println("Connected to database "+database);
/*
ctx= new InitialContext();
ds=(DataSource)ctx.lookup("jdbc/Domino-ZXwsj");
conn=ds.getConnection("sa","sa");
*/
s=conn.createStatement();
rs=s.executeQuery(sql);
while(rs.next())
{
System.out.println("kkkkkkkkkkkk");
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
conn.close();
}
catch (Exception e)
{
System.out.println("Error "+e.getMessage());
}
}
}
}
addview里这一句报错,怎么回事啊?