```
import java.awt.;
import java.awt.event.;
import java.sql.*;
import javax.swing.*;
public class login extends JFrame{
connection c=new connection();
Connection cc=c.getConnect();
public login(){
this.setTitle("登入界面");
this.setBounds(600,400,300,200);
final JTextField text1;
final JPasswordField text2;
JButton button1;
setLayout(new GridLayout(5,1));
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setVisible(true);
add(new JLabel("账户名"));
text1=new JTextField(10);
add(text1);
add(new JLabel("密码"));
text2=new JPasswordField(10);
add(text2);
button1=new JButton("登入");
add(button1);
button1.addActionListener(new ActionListener(){
PreparedStatement ps=null;
public void actionPerformed(ActionEvent e){
try {
String username1=text1.getText();
String password1=text2.getText();
String sql="select * from admin where username = ? and password = ?";
PreparedStatement ps=cc.prepareStatement(sql);
ps.setString(1,username1);
ps.setString(2,password1);
ResultSet rs=ps.executeQuery();
if(rs.next()){
admin ad=new admin();
ad.setVisible(true);
}
else{
JOptionPane.showMessageDialog(null,"用户名或密码错误");
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
});
}
}
```数据库连接上了PreparedStatement ps=cc.prepareStatement(sql);这句话为啥报错啊
return错了 或者改成如下:
import java.sql.*;
public class connection{
public Connection getConnect(){
Connection con=null;
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String conStr = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=hospital";
String dbUserName = "sa";
String dbPassword = "990729";
try{
Class.forName(driverName);
con =DriverManager.getConnection(conStr,dbUserName,dbPassword);
System.out.println("SQL Server连接成功!");
return con;
}
catch(Exception ex){
System.out.print("SQL Server连接失败!");
return null;
}
}
}
很有可能是连接cc数据库连接的问题,有没有相关错误提示
cc为null, 应该还是数据库没有连接成功 往上翻翻 肯定还有报错 仔细检查数据库连接 还有jar
import java.sql.*;
public class connection{
public Connection getConnect(){
Connection con=null;
String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String conStr = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=hospital";
String dbUserName = "sa";
String dbPassword = "990729";
try{
Class.forName(driverName);
Connection dbConn=DriverManager.getConnection(conStr,dbUserName,dbPassword);
System.out.println("SQL Server连接成功!");
return con;
}
catch(Exception ex){
System.out.print("SQL Server连接失败!");
return null;
}
}
}