以下是纯JDBC连接数据库的代码,但连接不到数据库,抛出异常java.sql.SQLException: No suitable driver

keni4516437 keni4516437 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
package jdbc_odbc;

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.table.DefaultTableModel;
import java.sql.*;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.util.Vector;

public class Frame_jbdc
extends JFrame {
public JButton jButton1 = new JButton();
public XYLayout xYLayout1 = new XYLayout();
public JScrollPane jScrollPane1 = new JScrollPane();
public JTable table = new JTable();
DefaultTableModel dt=new DefaultTableModel();
public Frame_jbdc() {
try {
jbInit();
}
catch (Exception exception) {
exception.printStackTrace();
}
}

private void jbInit() throws Exception {
getContentPane().setLayout(xYLayout1);
jButton1.setText("jButton1");
jButton1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
jButton1_actionPerformed(e);
}
});
this.getContentPane().add(jButton1, new XYConstraints(18, 9, 100, 28));
this.getContentPane().add(jScrollPane1, new XYConstraints(44, 54, 313, 196));
jScrollPane1.getViewport().add(table);
dt.addColumn("电脑编号");
dt.addColumn("状态");
dt.addColumn("备注");
//createTableModel();
table.setModel(dt);

}

public void jButton1_actionPerformed(ActionEvent e) {
String url="jdbc:microsoft:sqlserver://";
String serverName="keni";
String portNumber="1434";
String databaseName="netbar";
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
}
catch (ClassNotFoundException ex) {
ex.printStackTrace();
}
try {
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://keni:1433;databaseName=netbar;","sa","123");
Statement s = con.createStatement();
String strSel = "select * from Computer";
ResultSet rs = s.executeQuery(strSel);
if (table.getRowCount() > 0) {
for (int i = 0; table.getRowCount() > 0; i++) {
dt.removeRow(0);
}
}
while (rs.next()) {
Vector v=new Vector();
v.addElement(rs.getString(1));
v.addElement(rs.getString(2));
v.addElement(rs.getString(3));
dt.addRow(v);
}

rs.close();
s.close();
con.close();

}
catch (SQLException ex1) {
ex1.printStackTrace();
}
}
}
...全文
评论 12
收藏 已收藏
分享
返回顶部
keni4516437
Web 开发 81,108 成员 341,721 内容