我写了个数据库的链接类
package db;
import java.sql.*;public class ConnDB
{
public Connection conn=null;
public Statement st=null;
public String bd_Drive="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public Connection mygetConn() throws Exception{
Class.forName(bd_Drive);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db";
String user="sa";
String pwd="";
conn=DriverManager.getConnection(url,user,pwd);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
return conn;
}public void getConn()throws Exception
{
Class.forName(bd_Drive);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db";
String user="sa";
String pwd="";
conn=DriverManager.getConnection(url,user,pwd);}public ResultSet getRs(String sql)throws Exception
{
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery(sql);
return rs;
}public void getUpdate(String sql)throws Exception
{
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(sql);
}public void closeConn() throws Exception
{
if(st!=null)
st.close();
st=null; if(conn!=null)
conn.close();
conn=null;
}
}文件调用:package com;
import java.sql.*;import db.*;import db.ConnDB;
public class newManage
{
ConnDB con= new ConnDB();
private String userid,password,qy,username,bm,job,type; public void setUserid(String u){userid=u;}
public String getUserid(){return userid;} public void setPassword(String p){password=p;}
public String getPassword(){return password;} public void setQy(String q){qy=q;}
public String getQy(){return qy;} public void setUsername(String n){username=n;}
public String getUsername(){return username;} public void setBm(String b){bm=b;}
public String getBm(){return bm;} public void setJob(String j){job=j;}
public String getJob(){return job;} public void setType(String t){type=t;}
public String getType(){return type;}
public void updateDatabase(){
con.mygetConn(); String sql="Insert Into Manages(userid,[password],qy,username,job,bm,type) values(?,?,?,?,?,?,?)";
PreparedStatement perstmt=conn.prepareStatement(sql);
perstmt.setString(1,userid);
perstmt.setString(2,password);
perstmt.setString(3,qy);
perstmt.setString(4,username);
perstmt.setString(5,job);
perstmt.setString(6,bm);
perstmt.setString(7,type);
perstmt.executeUpdate(); }
}问题 :PreparedStatement perstmt=conn.prepareStatement(sql);
这行报错,conn,未定义,请高手帮忙.我是想通过调用 con.mygetConn();后有个conn可以使用.
package db;
import java.sql.*;public class ConnDB
{
public Connection conn=null;
public Statement st=null;
public String bd_Drive="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public Connection mygetConn() throws Exception{
Class.forName(bd_Drive);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db";
String user="sa";
String pwd="";
conn=DriverManager.getConnection(url,user,pwd);
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
return conn;
}public void getConn()throws Exception
{
Class.forName(bd_Drive);
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db";
String user="sa";
String pwd="";
conn=DriverManager.getConnection(url,user,pwd);}public ResultSet getRs(String sql)throws Exception
{
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery(sql);
return rs;
}public void getUpdate(String sql)throws Exception
{
st=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
st.executeUpdate(sql);
}public void closeConn() throws Exception
{
if(st!=null)
st.close();
st=null; if(conn!=null)
conn.close();
conn=null;
}
}文件调用:package com;
import java.sql.*;import db.*;import db.ConnDB;
public class newManage
{
ConnDB con= new ConnDB();
private String userid,password,qy,username,bm,job,type; public void setUserid(String u){userid=u;}
public String getUserid(){return userid;} public void setPassword(String p){password=p;}
public String getPassword(){return password;} public void setQy(String q){qy=q;}
public String getQy(){return qy;} public void setUsername(String n){username=n;}
public String getUsername(){return username;} public void setBm(String b){bm=b;}
public String getBm(){return bm;} public void setJob(String j){job=j;}
public String getJob(){return job;} public void setType(String t){type=t;}
public String getType(){return type;}
public void updateDatabase(){
con.mygetConn(); String sql="Insert Into Manages(userid,[password],qy,username,job,bm,type) values(?,?,?,?,?,?,?)";
PreparedStatement perstmt=conn.prepareStatement(sql);
perstmt.setString(1,userid);
perstmt.setString(2,password);
perstmt.setString(3,qy);
perstmt.setString(4,username);
perstmt.setString(5,job);
perstmt.setString(6,bm);
perstmt.setString(7,type);
perstmt.executeUpdate(); }
}问题 :PreparedStatement perstmt=conn.prepareStatement(sql);
这行报错,conn,未定义,请高手帮忙.我是想通过调用 con.mygetConn();后有个conn可以使用.
解决方案 »
- java axis2调用webservice问题 求指教
- SSH中OpenSessionInViewFilter中部分失效是什么原因
- 散分
- Tomcat5.0.28 中的jsp问题?
- 遇到这样的问题,你会怎么办 @_@
- 急:在表单中有radio单选按钮,提交了以后,我怎么知道我选的是那一个按钮?
- 求牛人在空闲的时候帮我解决下,用MyBatis,Spring,Struts2.谢谢
- 大家说,这种调用方式对么?
- 想做一个能在单机上(最好是win98上可以)的运行的jsp程序,用浏览器作客户端,请问是否可行?
- 关于日期
- 一个关于iframe的问题
- 为什么我用中文注册之后在页面中显示的是????但是在数据库中显示正常
Connection conn=null;
try {
conn=con.mygetConn();
String sql="Insert Into Manages(userid,[password],qy,username,job,bm,type) values(?,?,?,?,?,?,?)";
PreparedStatement perstmt=conn.prepareStatement(sql);
perstmt.setString(1,userid);
perstmt.setString(2,password);
perstmt.setString(3,qy);
perstmt.setString(4,username);
perstmt.setString(5,job);
perstmt.setString(6,bm);
perstmt.setString(7,type);
perstmt.executeUpdate();
}catch(Exception e) {
e.printStackTrace();
}
}