infol.java

JSP简单的OA系统_非常不错的一个系统

package com.zh.util;
import java.sql.*;
import com.zh.conpool.*;
public class Infol{
	String sql;
	PreparedStatement pstmt;
	ResultSet rs;
	int temp=0;
	Condata con=new Condata();
	Connection conn=null;
	public Infol(){
	}
	public String InsertSql(String str_table,int id,String dattime,String linkman,String test,String result){
		sql="insert into "+str_table+"(ClientId,Dattime,Linkman,Test,Result)values('"+id+"','"+dattime+"','"+linkman+"','"+test+"','"+result+"')";
		return sql;
				/*pstmt=conn.prepareStatement("insert into "+str_table+" [ClientId],[Dattime],[Linkman],[Test],[Result])values(?,?,?,?,?))";
	    //pstmt = con.prepareStatement("INSERT INTO [USER] ([Id],[Username],[Password],[Shopname],[Area],[Peopleman],[Mantel],[Shoptel],[Usertype],[Createdate],[Status]) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
		pstmt.setInt(1,id);
		pstmt.setString(2,dattime);
		pstmt.setString(3,linkman);
		pstmt.setString(4,test);
		pstmt.setString(5,result);
		pstmt.executeUpdate();
			
		
		/*pstmt.setString(2, StringUtils.toChinese(Username));
        pstmt.setString(3, StringUtils.toChinese(Password));
        pstmt.setString(4, StringUtils.toChinese(Shopname));
        pstmt.setString(5, StringUtils.toChinese(Area));
        pstmt.setString(6, StringUtils.toChinese(Peopleman));
        pstmt.setString(7, StringUtils.toChinese(Mantel));
        pstmt.setString(8, StringUtils.toChinese(Shoptel));
        pstmt.setInt(9, Usertype);
        pstmt.setString(10, StringUtils.toChinese(Createdate));
        pstmt.setInt(11, Status);
        pstmt.executeUpdate();*/
	}

}