主题:[原创]求助呀。。我怎么看也看不出错来了
package text;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
public class DbConn {
String drv = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver:// localhost:1433 DatabaseName=text";
Connection conn=null ;
public DbConn()
{
try {
Class.forName(drv);
}
catch (Exception ex) {
System.out.println("连接出错");
}
}
public Connection getConn()
{
try {
conn = DriverManager.getConnection(url,"sa","sa");
}
catch (Exception ex) {
System.out.println("出错");
return null;
}
return conn;
}
public int getTian( )
{
int falg=0;
Text t = new Text();
String sql = "insert yonghu values('"+t.getName()+"','"+t.getPass()+"','"+t.getAddress()+"','"+t.getPhone()+"')";
try {
conn = getConn();
Statement st = conn.createStatement();
falg = st.executeUpdate(sql);
}
catch (Exception ex) {
System.out.println("添加出错");
}
return falg;
}
}
这是连接数据库的 为什么老返回出错 驱动能找到
是不是我的URL 写错了呀,,高人指点一下了。 。我是实在找不出来了
求助下,,小弟先谢谢了
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
public class DbConn {
String drv = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver:// localhost:1433 DatabaseName=text";
Connection conn=null ;
public DbConn()
{
try {
Class.forName(drv);
}
catch (Exception ex) {
System.out.println("连接出错");
}
}
public Connection getConn()
{
try {
conn = DriverManager.getConnection(url,"sa","sa");
}
catch (Exception ex) {
System.out.println("出错");
return null;
}
return conn;
}
public int getTian( )
{
int falg=0;
Text t = new Text();
String sql = "insert yonghu values('"+t.getName()+"','"+t.getPass()+"','"+t.getAddress()+"','"+t.getPhone()+"')";
try {
conn = getConn();
Statement st = conn.createStatement();
falg = st.executeUpdate(sql);
}
catch (Exception ex) {
System.out.println("添加出错");
}
return falg;
}
}
这是连接数据库的 为什么老返回出错 驱动能找到
是不是我的URL 写错了呀,,高人指点一下了。 。我是实在找不出来了
求助下,,小弟先谢谢了