Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test;User=username;Password=password"); 这个是通过JDBC连接，数据库连接有很多种
Connection conn = DriverManager.getConnection
("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test;User=username;Password=password"); 这个是通过JDBC连接，数据库连接有很多种
//要进行验证的用户名和密码
String username="username";
String password="password";
//从数据库中选这用户名所对应的密码的sql
String strSQL="BEGIN USE "数据库名" SELECT password FROM "表名" WHERE username='"+username+"' END";
try
{
//连接数据库
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:test","数据库用户名", "密码");
Statement stmt=conn.createStatement();
//执行查询
ResultSet rs=stmt.executeQuery(strSQL);
//如果密码符合，flag为真。
if(rs.getString(2).equal(password))
{
flag = true;
}
else
{
flag = false;
]
stmt.close();
conn.close();
}
catch(Exception fe)
{
}
这句话应该怎么写,我有一个SQL的数据库表名叫club_test,里面有name 和password 两个类
我的数据库没有密码
Connection conn = DriverManager.getConnection("jdbc:odbc:test","数据库用户名", "密码");
这句话是不是应该:Connection conn = DriverManager.getConnection("jdbc:odbc:test","数据库用户名", "密码");
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
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 test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
package club;
import java.sql*;public class club_dbconnect{
string sdbdriver="sun.jdbc.jdbcodbcdriver";
string sconnstr="jdbc:club_test";//club_test 为数据源名
connection conn=null;
resultset rs=null; public club_dbconnect(){
try{
class.forname(sdbdriver);
}
catch(java.lang.classnotfoundexception e ){
system.err.println("class club_dbconnect not found!"=e.getmessage()");
}
}public resultset executequery(string sql){
rs=null;
try{
conn=drivermanager.getconnection(sconnstr,"sa","");
statement stmt=conn.createstatement(java.sql.resultset.type_scroll_insensitive.fava.sq;.resultset.concur_read_only);
rs=stmt.executequery(sql);
}
catch(sqlexception ex){
system.err.println("aq.executequery:"+ex.getmessage());
}
return rs;
}
public resultset executeupdate(string sql){
rs=null;
try{
conn=drivermanager.getconnection(sconnstr,"sa","");
statement stmt=conn.createstatement();
rs=stmt.executequery(sql);
}
catch(sqlexception ex){
system.err.println("aq.executequery:"=ex.getmessage());
}
return rs;
}
}
import java.sql.* 是加载java中sql文件
string sdbdriver="sun.jdbc.jdbcodbcdriver";加载数据库连接驱动程序
string sconnstr="jdbc:club_test"; 加载你数据库中你的所建的一个库对了，懒的说了，我把我做的一个贴上来:
我建立了个manage库，user表
bean文件为：
package onlineshop;
import java.sql.*;public class ConncetUser {
Connection con = null;
ResultSet rs = null; public ConncetUser()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e) { }
} public ResultSet executeQuery(String sql)
{
rs = null;
try
{
con = DriverManager.getConnection("jdbc:odbc:manage","sa","");
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {}
return rs;
}
}jsp文件为:
<%@ page import="java.sql.*"contentType="text/html;charset=gb2312"%>
<jsp:useBean id="workM" scope="page" class="onlineshop.ConncetUser" />
<html>
<head>
<script language="JavaScript">
function check_input()
{
if(document.theform.newLogname.value.length==0)
{
alert("请输入登陆姓名");
return false;
}
if(document.theform.newPassword.value.length==0)
{
alert("请输入登陆密码");
return false;
}
return true;
}
</script>
</head>
<body bgcolor="#EEF7EE">
<%@ include file="PublicHead.jsp" %>
<hr color="blue">
<div style="position:absolute;left:206px;top:166px;z-index:1;width:350;height:115px">
<div align="center"><form name="theform" action="" method="post" onsubmit="return check_input()">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFCC99">
<td width="40%"> <font size="3">登陆姓名: </font></td>
<td width="60%" colspan="4">
<input type="text" name="newLogname" size="15">
</td>
</tr>
<tr bgcolor="#FFCC99">
<td width="40%"> <font size="3">登陆密码: </font></td>
<td width="60%" colspan="4">
<input type="text" name="newPassword" size="15">
</td>
</tr>
<tr bgcolor="#FFCC99">
<td>
<center><input type="submit" name="Submit" value="确定"></center>
</form>
</td>
<td>
<form action="UserRegister.jsp" method="post">
<center><input type="submit" name="Submit2" value="注册"></center>
</form>
</td>
<td>
<form action="ForgetPassword.jsp" method="post">
<center><input type="submit" name="forget" value="忘记密码"></center>
</form>
</td>
</table>
</form>
</div>
</div>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<%
String newLogname=request.getParameter("newLogname");
if(newLogname==null)
{ newLogname=""; } String newPassword=request.getParameter("newPassword");
if(newPassword==null)
{ newPassword=""; } ResultSet rs=null; String condition="SELECT * FROM users WHERE name="+"'"+newLogname+"'";
rs=workM.executeQuery(condition);
boolean line=rs.next();
if(line==true)
{
String n=rs.getString("name");
String s=rs.getString("password");
if(newLogname.equals(n)&&newPassword.equals(s))
{
out.print("success");
session.setAttribute("newLogname",newLogname);
session.setAttribute("newPassword",newPassword);
String s1=response.encodeRedirectURL("PageForCommonUser.jsp");
response.sendRedirect(s1);
}
else
{
out.print("请输入正确的密码!");
}
}
else
{ out.print("请输入正确的姓名!"); }%>
</body>
</html>
我的程序如下：
package test;
import java.io.*;
import java.util.*;
import java.sql.*;
public class connect_sqlserver2000 {
String user="sa"; //连接数据库的用户名
String password="sa"; //连接数据库的密码，
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
//上面一行为访问sql server2000的数据库地址和名字
String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//上面一行为访问sql server2000的数据库的驱动程序地址，建议把驱动放在tomcat的WEB-INF/classes下
Connection con=null;
public ResultSet rst=null;
Statement smt=null;
public void init()
{
System.out.print("\n\n ----------欢迎使用 sql server2000 数据库----------李永沐\n\n");
rst=null;
try
{
Class.forName(driver);
System.out.print("\n\n 1.恭喜你,初始化数据库驱动程序成功！！！\n");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("\n\n 1.初始化数据库驱动程序出错，请检查sql server2000的驱动程序是否配置正确。建议把驱动放在tomcat的WEB-INF/classes下。即:函数==>>init()出错。\n\n"+e.getMessage());
}
}
public ResultSet executequery(String sql)
{
try
{
con=DriverManager.getConnection(url,user,password);
Statement smt=con.createStatement();
rst=smt.executeQuery(sql);
System.out.print("\n\n 2.恭喜你,查询数据库成功！！！即：==>>executequery()操作成功。\n\n");
}
catch(SQLException ex)
{
System.err.println("\n\n 2.操作查询数据库失败,请检查数据库地址、用户名、密码以及你的SQL语句是否正确。即：==>>executeQuery()出错。\n\n"+ex.getMessage());
}
return rst ;
}
public void executeupdate(String sql)
{
try
{
con=DriverManager.getConnection(url,user,password);
Statement smt=con.createStatement();
smt.executeUpdate(sql);
System.out.print("\n\n 2.恭喜你,更新数据库成功！！！即：==>>executeupdate()操作成功。\n\n");
smt.close();
con.close();
}
catch(SQLException ex)
{
System.err.println("\n\n 2.操作更新数据库失败,请检查数据库地址、用户名、密码以及你的SQL语句是否正确.即：==>>executeQuery()出错。\n\n"+ex.getMessage());
}
}}下面是JSP代码：：：：：
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<html>
<body>
<jsp:useBean id="id" scope="request" class="test.connect_sqlserver2000"/>
<% String sql="";
ResultSet rs="";
%>
<%
id.init();
sql = "INSERT INTO User (user_Name) VALUES ('yangwu')";
id.executeupdate(sql);
sql = "SELECT user_Id,user_Name from User";
rs = id.executequery(sql);
out.println("<table border=1 width=400>");
while (rs.next())
{
String col1 = rs.getString(1);
String col2 = rs.getString(2);
//打印所显示的数据
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td></tr>");
}
out.println("</table>");
}
/*以try开始
try
{
Connection con;
Statement stmt;
ResultSet rs;
//加载驱动程序，下面的代码为加载JDBD-ODBC驱动程序
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//用适当的驱动程序连接到数据库，member 是系统dsn名
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
//建立连接，类似于ASP中的创建数据库联接
con=DriverManager.getConnection(url, "", "5222117");
out.println("dfd");
//创建一个JDBC声明
stmt = con.createStatement();
//增加新记录
stmt.executeQuery("INSERT INTO User (user_Name) VALUES ('yangwu')");
//查询记录
rs = stmt.executeQuery("SELECT user_Id,user_Name from User");
//输出查询结果
out.println("<table border=1 width=400>");
while (rs.next())
{
String col1 = rs.getString(1);
String col2 = rs.getString(2);
//打印所显示的数据
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td></tr>");
}
out.println("</table>");
}
//如果加载时出错，给出相应的错误信息
catch (Exception e) {
out.println(e);
} */
%>
</body>
</html>驱动没找到，
把那几个jar文件放到jdk\jre\lib\ext\里用的是什么服务器啊，tomcat，那就把msbase.jar,mssqlserver.jar,msutil.jar这三个文件放在..tomcat/commom/lib下。