打错了,再贴一下
import java.sql.*;public class test
{
public static void main(String[] args){
String Url="jdbc:odbc:driver={SQL Server};SERVER=local;;;database=test";
Connection con;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
} try{
con = DriverManager.getConnection(Url);
con.close();
}catch(SQLException e){
System.err.println("SQLException: " + e.getMessage());
}
}
}
import java.sql.*;public class test
{
public static void main(String[] args){
String Url="jdbc:odbc:driver={SQL Server};SERVER=local;;;database=test";
Connection con;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
} try{
con = DriverManager.getConnection(Url);
con.close();
}catch(SQLException e){
System.err.println("SQLException: " + e.getMessage());
}
}
}
解决方案 »
- 两个非常简单的文件,却编译不过...
- StringBuffer 中append的问题!编译通过,执行报错,救急!
- java中的frame对象如何获得播放音乐的audioclip接口的实例呢 ?
- 图片怎么显示不出来啊?
- 继续问这个问题!
- try语句块中的return和finally中的try语句返回的结果存放在内存的哦什么地方
- 我手动删除了jbuilder6自带的jdk,如何才能让jbuilder用我其他地方的jdk呀?
- jfreechart 解压后怎么在JBUILDER中运行
- java.awt 和java.util都有List,想调用awt的List而出现Ambiguous class错误怎么办?
- 高分求解,关于取得application变量
- 类实例化时,能否动态分配类属性??求助各位高手!!
- 为什么看不到结果?
推荐TwFreeTds。
public class LoginConnection{
Connection connection;
public Connection getConnection(){
String url = "jdbc:odbc:databasename";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url,"","");
}catch(SQLException ex){
JOptionPane.showmessageDialog(null,ex.getMessage());
}
return;
}
}
你看里边的代码就是了。
<html>
<%@ page import = "java.sql.*" contentType="text/html;charset=gb2312" %>
<body>
Connect to Database....<br>
<%
String jdbcdriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;Databasename=Test";
String username = "sa";
String password = ""; Connection con = null;
Statement stmtUpdate = null;
Statement stmtQuery = null;
//
//Connection
// try{//Connect to Database
Class.forName(jdbcdriver);
con = DriverManager.getConnection(url,username,password);
}
catch(ClassNotFoundException e){
out.println("未发现类"+jdbcdriver);
}
catch(SQLException e){
out.println("Error in SQL Connection.");
}
%><br>
<%
//
//Query
// try{//Query from the Database
stmtQuery = con.createStatement();
String sql = "SELECT * FROM authors";
ResultSet rset = stmtQuery.executeQuery(sql);
while(rset.next()){
out.print(rset.getString(1) + " " + rset.getString(2));
out.print("<br>");
}
}
catch(SQLException e){
out.println("Error in SQL Query.");
}
%><br>
<%
//
//Update
// try{//Insert data to Database
stmtUpdate = con.createStatement();
String sql2 = "INSERT INTO jsj007.jsj007 values('21111729' , 'Machel')";
if(stmtUpdate.executeUpdate(sql2) == 1)
out.println("Insert data success!");
}
catch(SQLException e){
out.println("Error in SQL Update.");
}
%><br>
<%
//
//Close
//
try{//Close the connection
if(con != null){
stmtUpdate.close();
stmtQuery.close();
con.close();
}
}
catch(SQLException e){
out.println("Error in SQL Closing.");
}
%>
</body>
<html>要用MSSql先看你是不是装了JDBC for MS SQL
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:HRsystem","sa",null);
PreparedStatement stat=con.prepareStatement("insert into ExternalCandidate(cCandidateCode,vFirstName,vAddress,cPositionCode) values(?,?,?,?)");
stat.setString(1,data.applicantID);
stat.setString(2,data.applicantName);
stat.setString(3,data.applicantAddress);
stat.setString(4,data.applicantPosition);
stat.executeUpdate();
}
catch(Exception error)
{
System.out.println("Cann't insert the data in the table"+error);
}