我的连接页面是这样的
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" class="beans.connDB" scope="page"/>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>无标题文档</title>
</head><body>
<%
String wuliao=request.getParameter("textfield");
String pinming=request.getParameter("textfield2");
String shulian=request.getParameter("textfield3");
String danjia=request.getParameter("textfield5");
String jine=request.getParameter("textfield6");
String jiaoqi=request.getParameter("textfield4");
String gongyinshang=request.getParameter("textfield7");
String asql="Insert into wuliao(wuliao,pinming,shulian,danjia,jine,jiaoqi,gongyinshang) values('"+wuliao+"','"+pinming+"','"+shulian+"','"+danjia+"','"+jine+"','"+jiaoqi+"','"+gongyinshang+"')";
int set=connBean.executeUpdate(asql);
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatebaseName=mydatebase","sa","");
//创建数据库操作对象
//Statement stmt=conn.createStatement();
//int a=stmt.executeUpdate(asql);
//out.print(set);
if(set>0)
{
out.println("<script language='javascript'>alert('写入信息成功!');window.location.href='guanli.jsp';</script>");
}else{
out.println("<script language='javascript'>alert('写入信息失败!');window.location.href='ruku.html';</script>");
}
%>
</body>
</html>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connBean" class="beans.connDB" scope="page"/>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>无标题文档</title>
</head><body>
<%
String wuliao=request.getParameter("textfield");
String pinming=request.getParameter("textfield2");
String shulian=request.getParameter("textfield3");
String danjia=request.getParameter("textfield5");
String jine=request.getParameter("textfield6");
String jiaoqi=request.getParameter("textfield4");
String gongyinshang=request.getParameter("textfield7");
String asql="Insert into wuliao(wuliao,pinming,shulian,danjia,jine,jiaoqi,gongyinshang) values('"+wuliao+"','"+pinming+"','"+shulian+"','"+danjia+"','"+jine+"','"+jiaoqi+"','"+gongyinshang+"')";
int set=connBean.executeUpdate(asql);
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
//Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatebaseName=mydatebase","sa","");
//创建数据库操作对象
//Statement stmt=conn.createStatement();
//int a=stmt.executeUpdate(asql);
//out.print(set);
if(set>0)
{
out.println("<script language='javascript'>alert('写入信息成功!');window.location.href='guanli.jsp';</script>");
}else{
out.println("<script language='javascript'>alert('写入信息失败!');window.location.href='ruku.html';</script>");
}
%>
</body>
</html>
package unicoder;
import java.io.*;
public class ToUnicode{
public String toUnicode(String strText,String code) throws UnsupportedEncodingException{
char c;
String strRet="";
int intAsc;
String strHex;
strText = new String(strText.getBytes("ISO-8859-1"),code);
for(int i = 0;i < strText.length();i++){
c = strText.charAt(i);
intAsc = (int)c;
if(intAsc > 128){
strHex = Integer.toHexString(intAsc);
strRet = strRet + "&#x" + strHex + ";";
}
else{
strRet = strRet + c;
}
}
return strRet;
}
}
我忘了
可以点出来的 呵呵````