只是数据库操作类的一部份
package tryBag;import java.sql.*;
import java.util.*;public class DBHanlder {
private static Connection con ;
private static Statement smt ;
private static ResultSet exeQuery(String sql) throws SQLException
{
if(con ==null)
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try
{
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=SBookMC","","");
smt = con.createStatement();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
return smt.executeQuery(sql);
}
public static boolean isAuthrized(String name,String password)
{
String sql = "select * from ManagersTable where name='" + name
+ "' and password='" + password + "';"; try
{
ResultSet rs = exeQuery(sql);
return rs.next();
}
catch(SQLException e)
{
e.printStackTrace();
return false;
}
}
}在按钮的触发事件中的代码
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("登录"))
{
//这里还需要插入验证用户是否存在,以及输入是否正确的操作!栏位判断!
//db = new DBHanlder();
String loginName =jTextField.getText();
String passWord = jPasswordFieldPw.getText();
boolean isAuthrized = DBHanlder.isAuthrized(loginName,passWord);
if(isAuthrized)
{
mcFrame = new ManagerContralFrame(this);
this.dispose();
}
else
{
JOptionPane.showMessageDialog(this, "用户名或者密码不正确!");
}
}报错信息是:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect请求高人解答...在线等 ....谢谢了
package tryBag;import java.sql.*;
import java.util.*;public class DBHanlder {
private static Connection con ;
private static Statement smt ;
private static ResultSet exeQuery(String sql) throws SQLException
{
if(con ==null)
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch(ClassNotFoundException e)
{
e.printStackTrace();
}
try
{
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=SBookMC","","");
smt = con.createStatement();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
return smt.executeQuery(sql);
}
public static boolean isAuthrized(String name,String password)
{
String sql = "select * from ManagersTable where name='" + name
+ "' and password='" + password + "';"; try
{
ResultSet rs = exeQuery(sql);
return rs.next();
}
catch(SQLException e)
{
e.printStackTrace();
return false;
}
}
}在按钮的触发事件中的代码
public void actionPerformed(ActionEvent e)
{
if(e.getActionCommand().equals("登录"))
{
//这里还需要插入验证用户是否存在,以及输入是否正确的操作!栏位判断!
//db = new DBHanlder();
String loginName =jTextField.getText();
String passWord = jPasswordFieldPw.getText();
boolean isAuthrized = DBHanlder.isAuthrized(loginName,passWord);
if(isAuthrized)
{
mcFrame = new ManagerContralFrame(this);
this.dispose();
}
else
{
JOptionPane.showMessageDialog(this, "用户名或者密码不正确!");
}
}报错信息是:
com.microsoft.sqlserver.jdbc.SQLServerException: 到主机 的 TCP/IP 连接失败。 java.net.ConnectException: Connection refused: connect请求高人解答...在线等 ....谢谢了
do following check:start -> run enter cmd
then type "netstat -an" in your window console
then telnet serverhost 1433 (SQL Server 2000 default TCP port)
then check ODBC System DNS:
Administrative Tools -> Data Sources (ODBC)->System DNS tabmake sure everything is okay.....
reboot your machine.......