预编译语句增删改代码.pdfVIP

预编译语句的增删改

1Help.java

packagedbtest.util;

importjava.io.UnsupportedEncodingException;

publicclassHelp{

//码解决

publicstaticStringtoUtf(Stringstr)

{

try{

returnnewString(str.getBytes(ISO8859-1),UTF-8);

}catch(UnsupportedEncodingExceptione){

e.printStackTrace();

returnstr;

}

}

}

2productManage.jsp

%@pageimportdbtest.util.Help%

%@pageimportjava.sql.*%

%@pagelanguagejavacontentTypetext/html;charset=utf-8

pageEncodingutf-8%

//定义连接对象

Connectionconnnull;

//连接字符串

StringstrConnjdbc:sqlserver://localhost:1433;databaseName=ShopSystem;

//publicStringstrConn

jdbc:sqlserver://localhost:1433;databaseName=test;user=sa;password=123456;

StringstrUsersa;

StringstrPasswordadmin;

ResultSettypeRsnull;

StringpTypenull;

try{

//查找驱动

Class.forName(com..sqlserver.jdbc.SQLServerDriver);

conn=DriverManager.getConnection(strConn,strUser,strPassword);

Statementst=conn.createStatement();

StringsqlSELECTt_typeFROMmain_type;

typeRs=st.executeQuery(sql);

pType=request.getParameter(pType);

}catch(Exceptionef)

{

ef.printStackTrace();

}

%

div

%

Stringresult=request.getParameter(result);

if(result!null)

out.println(result);

%

formactionproductManage.jspmethodpost

产品类别：

selectnamepType

%

while(typeRs.next())

{

%

option

value%typeRs.getString(1)%%typeRs.getString(1)%/option

%}%

/select

inputtypesubmitvalue查询/

ahrefpAdd.jsp添加产品/a

/form

/div

%

ResultSetrsnull;

if(pType!null!pType.equals())

{

pType=Help.toUtf(pType);

try{

Stringsqlselect*fromProductwherep_type=?;

System.out.println(sql+pType);

PreparedStatementpst=conn.prepareStatement(sql);

pst.setString