String sql = "select * from PJXXMX where PJLX="+lx+" and SFYLYR="+sfy+" ";
PJLX和SFYLYR是什么数据类型的字段阿字符类型:String sql = "select * from PJXXMX where PJLX='"+lx+"' and SFYLYR='"+sfy+"' ";数字类型:String sql = "select * from PJXXMX where PJLX="+lx+" and SFYLYR="+sfy+" ";
PJLX和SFYLYR是什么数据类型的字段阿字符类型:String sql = "select * from PJXXMX where PJLX='"+lx+"' and SFYLYR='"+sfy+"' ";数字类型:String sql = "select * from PJXXMX where PJLX="+lx+" and SFYLYR="+sfy+" ";
解决方案 »
- 正则表达式的“\W”问题
- 求一个只能选择 年月 的日期空间 把您的js代码贴进来哈
- 百度地图如何在点“标记”后,弹出悬浮框以及更改鼠标光标显示样式?
- 谁有extjs下拉菜,支持模糊搜索的,显示菜单是多列的?
- 这段代码 会引起javascript 内存泄露问题吗?
- 我的JS语法高亮器
- 各位老大啊,帮帮我吧,下载了一下午的1st javascript editor,反倒没有下载成功,电脑中了假软件的木马数据全没有了,赠给我这个软件吧
- 外部JS文件怎样调试,进而找出错误啊???
- 一个输入输入框,限定多少个字符,然后没输入字符,下面就会提示还剩余多少个字符,谁有这个代码,谢谢大家
- 点击"刷新",本页面没有反映,怎么回事?
- 问下js里面的if语句写法??
- 看一下,这个到底是方法还是属性~~~看了半天没看懂??
我晕死了,jsp有你写的这么乱七八糟的么?简直糟蹋了java的优势啊!
//MySqlLib.java文件
import java.sql.*;
public class MySqlLib
{
private String driver="com.mysql.jdbc.Driver";//自己修改(最好从xml配置文件读取)
private String url="jdbc:mysql://localhost/test";//自己修改(最好从xml配置文件读取)
private String user="root";//自己修改(最好从xml配置文件读取)
private String password="root";//自己修改(最好从xml配置文件读取)
//private ConnSource dbSource=null;
private Connection conn=null;
private Statement stmt=null;
private CallableStatement callsta=null;//调用存储过程的时候需要
//构造函数里初始化dbSource
public MySqlLib()
{
//this.dbSource = ConnString.getConnSource();
}
//初始化conn
private void createConn()
{
try
{
Class.forName(this.driver).newInstance();
this.conn=DriverManager.getConnection(this.url,this.user,this.password);
}
catch(Exception e){ System.out.println(e.toString());}
//return con;
}
//初始化stmt
private void createStmt() throws Exception
{
if(this.conn==null || this.conn.isClosed())
this.createConn();
this.stmt = this.conn.createStatement();
//this.conn.createStatement();
}
//
public CallableStatement createCallsta(String st) throws Exception
{
if(this.conn==null || this.conn.isClosed())
this.createConn();
this.callsta=conn.prepareCall(st);
return this.callsta;
}
//执行sql语句,返回ResultSet结果集
public ResultSet executeQuery(String strSql) throws Exception
{
if(this.stmt==null)
this.createStmt();
return this.stmt.executeQuery(strSql);
}
//执行存储过程,返回ResultSet结果集
public ResultSet executeProcedure(CallableStatement callStmt) throws Exception
{
if(this.conn==null || this.conn.isClosed())
this.createConn();
//
if(callStmt==null) return null;
//
if(callStmt.execute())
return callStmt.getResultSet();
return null;
}
//释放资源
public void close() throws Exception
{
this.closeStmt();this.closeConn();
}
//
public void closeStmt() throws Exception
{
if(this.stmt!=null)
this.stmt.close();
this.stmt=null;
}
//
public void closeConn() throws Exception
{
if(this.conn!=null && !this.conn.isClosed())
this.conn.close();
this.conn=null;
}
}
//SqlDb.java文件
import java.sql.*;
import java.util.ArrayList;public class SqlDb
{
public ArrayList<String> getKeyword() throws Exception
{
MySqlLib lib = new MySqlLib();
ArrayList<String> arr = new ArrayList<String>();
ResultSet rs = lib.executeQuery("select * from test order by id asc");
if(rs!=null)
{
while(rs.next())
{
arr.add(rs.getString("keyword"));
}
rs.close();
lib.close();
}
return arr;
}
//使用存储过程的
public ArrayList<String> getCity() throws Exception
{
MySqlLib lib = new MySqlLib();
ArrayList<String> arr = new ArrayList<String>();
String st="{call getCity()}";//不需要参数
//CallableStatement callsta = lib.createCallsta(st);
//callsta.setInt("num",102);//设置参数
//callsta.setString("Title","卢楚风");
ResultSet rs = lib.executeProcedure(lib.createCallsta(st));
if(rs!=null)
{
while(rs.next())
{
arr.add(rs.getString("city"));
}
rs.close();
lib.close();
}
return arr;
}
}
//给你两个类,你自己参考下...
//输出数据库里的内容,我直接在ShowMsg.java里输出了,你可以把ShowMsg.java换成任意的web页面,只要条用上面两个类的方法即可
import java.util.ArrayList;public class ShowMsg
{
private static void cout(String obj)
{
System.out.print(obj);
}
//
private static void coutln(String obj)
{
System.out.println(obj);
}
//
private static void cout(Object obj)
{
System.out.print(obj);
}
//
private static void coutln(Object obj)
{
System.out.println(obj);
}
//以上几个函数最好在一个工具类里单独定义吧,如果需要的话
private static void msg() throws Exception
{
SqlDb db = new SqlDb();
ArrayList<String> arr = new ArrayList<String>();
arr = db.getKeyword();
for(int i=0;i<arr.size();i++)
{
coutln(arr.get(i).toString() + "\n");
}
}
//
private static void city() throws Exception
{
SqlDb db = new SqlDb();
ArrayList<String> arr = new ArrayList<String>();
arr = db.getCity();
for(int i=0;i<arr.size();i++)
{
coutln(arr.get(i).toString() + "\n");
}
}
//
public static void main(String[] args) throws Exception
{
msg();//city();
}
}