偶想用java程序来连接mysql,用下面的程序可以么?怎么执行后出错啊:( import java.sql.*;public class MySqlConnect { public static void main(String[] args) { //声名 Connection Conn; Statement Stmt; ResultSet RS; String url = "jdbc:mysql//localhost/test"; String name = "test"; String pwd = "test"; String sql = "select * from test"; try { // The newInstance() call is a work around for some // broken Java implementations Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Conn = DriverManager.getConnection(url,name,pwd); // Do something with the Connection Stmt = Conn.createStatement();
如果是一直没连接上我觉得一概是你的设置的问题。
没有把mysql的端口号写上
("jdbc:mysql//192.168.85.119:3306/weboa?user=user&password=sa");
%TOMCAT_HOME%/common/lib下
再用这种方式连数据库。
("jdbc:mysql//192.168.85.119:3306/weboa?user=user&password=sa");
<%@ page contentType="text/html;charset=gb2312" %>
<html> <head>
<title>使用JDBC连接到数据库</title>
</head>
<body>
<center>
<%@ page import="java.sql.*"%>
<%
String driver="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://localhost:3306/family";//family是你在数据名
String userID="root";
String passwd=""; try
{
Class.forName(driver);
}
catch(Exception e)
{
out.println("无法载入"+driver+"驱动程序!");
e.printStackTrace();
}
try
{
Connection DBcon=DriverManager.getConnection(url,userID,passwd);
if(!DBcon.isClosed())
out.println("成功地连接至数据库!");
DBcon.close();
}
catch(SQLException SQLe)
{
out.println("无法连接至数据库!");
}
%>
</center>
</body>
</html>
import java.sql.*;public class MySqlConnect
{
public static void main(String[] args)
{
//声名
Connection Conn;
Statement Stmt;
ResultSet RS;
String url = "jdbc:mysql//localhost/test";
String name = "test";
String pwd = "test";
String sql = "select * from test"; try
{
// The newInstance() call is a work around for some
// broken Java implementations
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Conn = DriverManager.getConnection(url,name,pwd);
// Do something with the Connection Stmt = Conn.createStatement();
RS = Stmt.executeQuery(sql);
Conn.close();
}
catch(Exception E)
{
System.out.print(E);
}
}
}出错信息:
java.sql.SQLException: No suitable driver
一样少个mysql的端口号
String url = "jdbc:mysql//localhost:3306/test";
我看你的其它代码好像没有错误吧,我没有用java连过