用户 '' 登录失败。 ClientConnectionId:4a259d64-d6d2-4092-a8b7-9cf4e1300e2e

[CodingTrueMan]

package buyticket;

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.table.TableColumn;
import javax.swing.*;
public class MainFrame extends JFrame {

/**
*
*/
private static final long serialVersionUID = 1L;

JFrame jf = new JFrame();

//JPanel jp_title = new JPanel();
JPanel jp_input = new JPanel();
JPanel jp_showTicket = new JPanel();
JPanel jp_buttons = new JPanel();
// title
//JLabel lab_title = new JLabel("火车票订票系统");
// 填写内容
JLabel lab_sStation = new JLabel("始发站:");
JLabel lab_dStation = new JLabel("终点站:");
JLabel lab_sTime = new JLabel("开车时间:");
JLabel lab_trainID= new JLabel("车次");
// 内容
/*
* JLabel lab_turns= new JLabel("车次"); JLabel lab_sStations= new
* JLabel("始发站"); JLabel lab_dStations= new JLabel("终点站"); JLabel
* lab_sTimes= new JLabel("开车时间"); JLabel lab_prices= new JLabel("票价");
*/
JTextField tf_sStation = new JTextField(10);
JTextField tf_dStation = new JTextField(10);
JTextField tf_sTime = new JTextField(10);
JTextField tf_trainID=new JTextField(10);

JTable tab_showTicket=new JTable();
Object data[][]=null;
String[] titles = { "车次", "车号", "始发站", "终点站", "开车时间", "票价" ,"余票"};
String a0,a1,a2,a3;
JScrollPane jscrollPane=new JScrollPane(tab_showTicket);

JButton btn_mesQuery = new JButton("购票信息查询");
JButton btn_ticketQuery = new JButton("余票查询");

public MainFrame(String title) {

//jp_input.setLayout(new GridLayout(1,6));
//jp_sercher.setLayout(new );
//super(title);
//jf.setLayout(new GridLayout(4, 1));




tab_showTicket = new JTable(data, titles);
TableColumn column = null;

for (int i = 0; i < 6; i++) {
column = tab_showTicket.getColumnModel().getColumn(i);
if (i % 2 == 0) {
column.setPreferredWidth(150);
} else {
column.setPreferredWidth(150);
}
}
//JScrollPane scrollPane = new JScrollPane();



//jp_title.add(lab_title);
// jp_input添加组件
jp_input.add(lab_sStation);
jp_input.add(tf_sStation);
jp_input.add(lab_dStation);
jp_input.add(tf_dStation);
jp_input.add(lab_trainID);
jp_input.add(tf_trainID);
jp_input.add(lab_sTime);
jp_input.add(tf_sTime);
//jp_sercher添加组件
jp_buttons.add(btn_mesQuery);
jp_buttons.add(btn_ticketQuery);
//jp_showticket添加组件
//jp_showTicket.add(scrollPane);

//jf.add(jp_title);
jf.add(jp_input,BorderLayout.NORTH);
//jf.add(jp_sercher);
jf.getContentPane().add(jscrollPane,BorderLayout.CENTER);
jf.add(jp_buttons,BorderLayout.SOUTH);
jf.setTitle("火车票查询系统");

jf.setVisible(true);
//jf.setBounds(200, 200, 800, 600);
jf.setSize(800, 600);
jf.setDefaultCloseOperation(EXIT_ON_CLOSE);

//jf.setResizable(false);
btn_mesQuery.addActionListener(new myListener());
btn_ticketQuery.addActionListener(new myListener());

}

public class myListener implements ActionListener {

public void actionPerformed(ActionEvent e) {

if (e.getSource() == btn_mesQuery) {

}
if (e.getSource() == btn_ticketQuery) {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=TicketManager";
String userName = "sa";
String userPwd = "123456";
try
{

Class.forName(driverName);
Connection dbConn = DriverManager.getConnection(dbURL, userName,
userPwd);
System.out.println("连接数据库成功");
}
catch (Exception e1)
{
e1.printStackTrace();
System.out.print("连接失败");
}
Statement stmt = null;
Connection conn = null;
ResultSet rs = null;
try {

conn = DriverManager.getConnection(dbURL);
stmt = conn.createStatement();
String sql = "select *from Ticket where LeaveCity like'";
sql += tf_sStation + "'";
/*and ArriveCity='" + tf_dStation + "';";
sql += "'and LeaveTime="+tf_sTime+"'or TrainID="+tf_trainID+"'";*/
rs = stmt.executeQuery(sql);

int lr, lc;
for (lr = 0; lr < 30; lr++) {
for (lc = 0; lc < 6; lc++) {
data[lr][lc] = "";
}


int i = 0;

a0 = "'" + "%" + tf_sStation.getText().trim() + "%" + "'";
a1 = "'" + "%" + tf_dStation.getText().trim() + "%" + "'";
a2 = "'" + "%" + tf_sTime.getText().trim() + "%" + "'";
a3 = "'" + "%" + tf_trainID.getText().trim() + "%" + "'";
// 根据给定条件，进行查询
String temp = "select * from Tickets where LeaveCity like "
+ a0 + " and ArriveCity like " + a1
+ " and TrainID like " + a2 + " and LeaveTime like "
+ a3;
rs = stmt.executeQuery(temp);
// 显示符合要求的所有图书信息
while (rs.next()) {
data[i][0] = rs.getString(1);
data[i][1] = rs.getString(2);
data[i][2] = rs.getString(3);
data[i][3] = rs.getString(4);
data[i][4] = rs.getString(5);
data[i][5] = rs.getString(6);
i++;
}
}


}catch (SQLException ed) {
System.out.println(ed);
}

}
}


}






会出现错误
连接数据库成功
com.microsoft.sqlserver.jdbc.SQLServerException: 用户 '' 登录失败。 ClientConnectionId:4a259d64-d6d2-4092-a8b7-9cf4e1300e2e

还有 JScrollPane 添加 有没有错误，一开始这里有错误的