求助~连接不上,显示结果是成功然后失败,rs = stmt.executeQuery(sql);我觉得是这句的问题,求指导
import java.sql.Connection;SQL 数据库 jdbc java
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/*
* wwssy2d.java
*
* Created on __DATE__, __TIME__
*/
/**
*
* @author __USER__
*/
public class wwssy2d extends javax.swing.JFrame {
/** Creates new form wwssy2d */
public wwssy2d() {
initComponents();
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
//GEN-BEGIN:initComponents
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jButton1 = new javax.swing.JButton();
jTextField1 = new javax.swing.JTextField();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jButton1.setText("\u67e5\u8be2");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jLabel1.setText("\u8f93\u5165\u7535\u5f71\u540d\u79f0");
jLabel2.setText("\u5220\u9664\u5f71\u7247\u4fe1\u606f");
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object[][] { { null, null, null, null },
{ null, null, null, null }, { null, null, null, null },{ null, null, null, null }, { null, null, null, null },{ null, null, null, null }, { null, null, null, null },
{ null, null, null, null } }, new String[] { "影片编号",
"影片名称", "影厅编号", "放映时间" }));
jScrollPane1.setViewportView(jTable1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(
getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(layout.createParallelGroup(
javax.swing.GroupLayout.Alignment.LEADING).addGroup(
javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup().addContainerGap(31,
Short.MAX_VALUE).addComponent(jLabel1).addGap(27, 27,
27).addComponent(jTextField1,
javax.swing.GroupLayout.PREFERRED_SIZE, 130,
javax.swing.GroupLayout.PREFERRED_SIZE).addGap(45, 45,
45).addComponent(jButton1).addGap(38, 38, 38))
.addGroup(
layout.createSequentialGroup().addGap(156, 156, 156)
.addComponent(jLabel2).addContainerGap(172,
Short.MAX_VALUE)).addGroup(
layout.createSequentialGroup().addContainerGap()
.addComponent(jScrollPane1,
javax.swing.GroupLayout.PREFERRED_SIZE,
375,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(13, Short.MAX_VALUE)));
layout.setVerticalGroup(layout.createParallelGroup(
javax.swing.GroupLayout.Alignment.LEADING).addGroup(
layout.createSequentialGroup().addContainerGap().addComponent(
jLabel2).addGap(21, 21, 21).addGroup(
layout.createParallelGroup(
javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1).addComponent(
jTextField1,
javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1)).addGap(18, 18, 18)
.addComponent(jScrollPane1,
javax.swing.GroupLayout.PREFERRED_SIZE, 275,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE,
Short.MAX_VALUE)));
pack();
}// </editor-fold>
//GEN-END:initComponents
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
String DBURL = "jdbc:mysql://localhost:3306/test?useUnicode=true&charaters=gbk";
String DBUSER = "root";
String DBPASS = "123";
String cxmname = jTextField1.getText();//settext
ResultSet rs = null;
Connection conn = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
if (conn != null) {System.out.println("数据库连接成功!");
}
String sql = "SELECT movie_id,movie_room,movie_time FROM movie_im"+"WHERE movie_name = '"+cxmname+"'";// 插入数据sql的语句
Statement stmt = conn.createStatement(); // 创建用于执行静态sql语句的Statement对象
//int rows = stmt.executeUpdate(sql);
rs = stmt.executeQuery(sql);
if (rs.next()){ // 判断数据集中是否有数据
System.out.println("数据库中共有"+rs.getInt(1)+"条记录");
}
rs.close();
stmt.close();
conn.close(); //关闭数据库连接
}
catch (Exception e) {
System.out.println("数据库连接失败!");
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new wwssy2d().setVisible(true);
}
});
}
//GEN-BEGIN:variables
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
// End of variables declaration//GEN-END:variables
}
[解决办法]
错误信息
java error stack..
[解决办法]
java 抛出的异常信息。
[解决办法]
反编译的东西 ?
你跟一下 ,看看错误在哪里抛来的嘛
你可以写自己的测试类 ,把里面的数据库连接什么的都拿出来测试一下不就知道了 ?
[解决办法]
catch (Exception e) {
System.out.println("数据库连接失败!");
}
catch (Exception e) {
e.printStackTrace();
}