package com.bean; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; public class DB {
public static Connection getConn(){
Connection conn=null;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spdb1";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
conn=DriverManager.getConnection(url,"sa","123");
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
} public static Statement getStmt(Connection conn){
Statement stmt=null;
try {
stmt=conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
return stmt;
} public static ResultSet getQuery(int pageSize,int pageNow){
ResultSet rs=null;
Connection conn=getConn();
Statement stmt=getStmt(conn);
try {
rs=stmt.executeQuery("select top "+pageSize
+" * from users where userId not in (select top "
+pageSize*(pageNow-1)+" userId from users) ");
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
} public static void close(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn=null;
}
}
} public static void close(Statement stmt){
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
stmt=null;
}
}
} public static void close(ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
rs=null;
}
}
}
public static boolean checkuser(String usename,String password){
boolean b=false;
Connection conn=getConn();
Statement stmt=getStmt(conn);
try {
ResultSet rs=stmt.executeQuery("select passwd from users where username="+usename);
while(rs.next()){
if(rs.getString("passwd").equals("password")){
b=true;
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(conn);
close(stmt);
close(rs);//这里为什么不能引入,这里出现rs cannot be resolved.请帮助
}
return b;
} }
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; public class DB {
public static Connection getConn(){
Connection conn=null;
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spdb1";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
conn=DriverManager.getConnection(url,"sa","123");
} catch (InstantiationException e) {
e.printStackTrace();
} catch (IllegalAccessException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
} public static Statement getStmt(Connection conn){
Statement stmt=null;
try {
stmt=conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
return stmt;
} public static ResultSet getQuery(int pageSize,int pageNow){
ResultSet rs=null;
Connection conn=getConn();
Statement stmt=getStmt(conn);
try {
rs=stmt.executeQuery("select top "+pageSize
+" * from users where userId not in (select top "
+pageSize*(pageNow-1)+" userId from users) ");
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
} public static void close(Connection conn){
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn=null;
}
}
} public static void close(Statement stmt){
if(stmt!=null){
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
stmt=null;
}
}
} public static void close(ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
rs=null;
}
}
}
public static boolean checkuser(String usename,String password){
boolean b=false;
Connection conn=getConn();
Statement stmt=getStmt(conn);
try {
ResultSet rs=stmt.executeQuery("select passwd from users where username="+usename);
while(rs.next()){
if(rs.getString("passwd").equals("password")){
b=true;
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(conn);
close(stmt);
close(rs);//这里为什么不能引入,这里出现rs cannot be resolved.请帮助
}
return b;
} }
解决方案 »
- MyEclipse开发问题 ,求解 !
- 关于weblogic集群问题
- 数据库查询问题 两种方式不一样的结果
- 请教,哪里能找到Google,yahoo,LEC ,world language等等的翻译接口?
- 怎样使JfreeChart横坐标数据换行显示(在线等)
- 现在想问的是在j2ee中如何去象.net中的配置达到这样的安全验证机制!如何去配置web.xml文件!??
- struts2 <s:submit>加载图片的问题,在线等!
- jsp能够包含一个不在web站点内,但在本台服务器上的另外一个jsp文件?php是可以的。
- JSP页面自动数据刷新问题,,欢迎进入探讨!!!
- 谁有中文POI的API文档啊
- 为什么dwrutil.removeallopions() 无法使用
- 如何在MyEclipse中创建Tomcat工程
boolean b=false;
Connection conn=getConn();
Statement stmt=getStmt(conn);
ResultSet rs = null;
try {
//ResultSet rs=stmt.executeQuery("select passwd from users where username="+usename);
修改成
rs=stmt.executeQuery("select passwd from users where username="+usename);
while(rs.next()){
if(rs.getString("passwd").equals("password")){
b=true;
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
close(conn);
close(stmt);
close(rs);//这里为什么不能引入,这里出现rs cannot be resolved.请帮助
}
return b;
} }