package com.sunnitech.bean;import java.sql.Connection;
import java.sql.DriverManager;
public class DBConnection {
public static Connection getDBConnection() {
Connection conn = null; //String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PicViewDB";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:PicDB";
String user = "sa";
String pwd = ""; //密码为空 try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, user, pwd);
} catch(Exception e) {
System.out.println("DBConnect error: " + e.toString()); return null;
} return conn;
}
}
import java.sql.DriverManager;
public class DBConnection {
public static Connection getDBConnection() {
Connection conn = null; //String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
//String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=PicViewDB";
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:PicDB";
String user = "sa";
String pwd = ""; //密码为空 try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, user, pwd);
} catch(Exception e) {
System.out.println("DBConnect error: " + e.toString()); return null;
} return conn;
}
}
PreparedStatement pre=con.prepareStatement(sql);
pre.setString(1,username);
pre.setString(2,password);
ResultSet rs=pre.executeQuery();
rs.next();
role=rs.getString("role");
sqlStatement.close();
2.把jdbc驱动中三个JAR文件COPY到我的\JRE\LIB\EXT下(不用设置classpath)
3.写程序,调试运行import java.sql.*;
public class JDBC_Connect {
public static void main(String[] args) {
Connection conn;
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=myjava";
String user = "sa";
String pwd = "1356786";
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
System.out.println("Error: " + e.toString());
}
System.out.println("Finished!");
}
}String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=myjava";
这里的ip是服务器的ip地址看看下面这个帖子吧,应该能明白很多
http://community.csdn.net/Expert/topic/3670/3670348.xml?temp=.409527
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=base";
String user="sa"; //用户名
String password=""; //密码
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from 表名";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
<%=rs.getString(1)%>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
首先要有相应的jdbc驱动
在程序里
就像楼上的几位那样
要是是SQL的话,要下在SQLJDBC驱动程序
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class ShareInquire extends HttpServlet
{ Connection con=null; //共享连接。
String url="jdbc:oracle:thin:@localhost:1521:mymis";
String user="scott";
String password="tiger";
public void init(ServletConfig config) throws ServletException
{super.init(config);
//加载JDBC驱动:
try{Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e){}
}
//通过Post方法按名字查询记录:
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException
{ PrintWriter out=response.getWriter();
response.setContentType("text/html;charset=GB2312");//设置响应的MIME类型。
out.println("<HTML>");
out.println("<BODY>");
if(con==null)
{ try
{ //第一个用户负责建立连接con。
con=DriverManager.getConnection(url,user,password);
Statement sql=con.createStatement();
String sql="select * from students";
ResultSet rs=sql.executeQuery(sql);
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"Number");
out.print("<TH width=100>"+"Name");
out.print("<TH width=50>"+"Math");
out.print("<TH width=50>"+"English");
out.print("<TH width=50>"+"Phsics");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getString(1)+"</TD>");
out.print("<TD >"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getInt(3)+"</TD>");
out.print("<TD >"+rs.getInt(4)+"</TD>");
out.print("<TD >"+rs.getInt(5)+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
}
catch(SQLException e)
{
}
}
//其它客户通过同步块使用这个连接:
else
{ synchronized(con)
{try{ Statement stmt=con.createStatement();
String sql="SELECT * FROM students";
ResultSet rs=stmt.executeQuery(sql);
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"Number");
out.print("<TH width=100>"+"Name");
out.print("<TH width=50>"+"Math");
out.print("<TH width=50>"+"English");
out.print("<TH width=50>"+"Phsics");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD >"+rs.getString(1)+"</TD>");
out.print("<TD >"+rs.getString(2)+"</TD>");
out.print("<TD >"+rs.getInt(3)+"</TD>");
out.print("<TD >"+rs.getInt(4)+"</TD>");
out.print("<TD >"+rs.getInt(5)+"</TD>");
out.print("</TR>") ;
}
out.print("</Table>");
}
catch(SQLException e)
{
}
}
}
out.println("</BODY>");
out.println("</HTML>");
}
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws ServletException,IOException
{ doPost(request,response);
}
}
/************************************************************************
以上是SERVLET同步连接数据库