資源簡介
JSP 和 JavaBean連接sql server驗證登錄
這是一個小demo

代碼片段和文件信息
package?com.jkxy.conn;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?util.PropertiesUtils;
public?class?conn?{
public?Connection?getCon()
{
String?searchurl?=?null;
String?inserturl?=?“jdbc:sqlserver://localhost:1433;databaseName=jkstudent“;
String?user?=?“sa“;
String?password?=?“0824Pp“;
String?settime?=?null;
// PropertiesUtils.loadFile(“dbconfig.properties“);
// searchurl?=?PropertiesUtils.getPropertyValue(“SEARCHURL“);
// inserturl?=?PropertiesUtils.getPropertyValue(“INSERTURL“);
// user?=?PropertiesUtils.getPropertyValue(“USER“);
// password?=?PropertiesUtils.getPropertyValue(“PASSWORD“);
// settime?=?PropertiesUtils.getPropertyValue(“SETTIME“);
try{
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver“);
// String?url=“jdbc:sqlserver://localhost/jkstudent“;
//// String?url=“jdbc:sqlserver://172.16.91.184/FilmClub_XJCmcc?useUnicode=true&characterEncoding=utf-8“;
// String?user=“bing“;
// String?password=“0824pP“;
Connection?conn?=?(Connection)?DriverManager.getConnection(inserturl?user?password);
System.out.println(conn.getmetaData().getURL());
return?conn;
}
catch(Exception?e){
e.printStackTrace();
return?null;
}
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????912??2015-07-04?10:51??dbtest\.classpath
?????文件???????1039??2015-07-04?10:15??dbtest\.project
?????文件????????567??2015-07-04?10:15??dbtest\.settings\.jsdtscope
?????文件?????????69??2015-07-04?10:26??dbtest\.settings\org.eclipse.core.resources.prefs
?????文件????????364??2015-07-04?10:15??dbtest\.settings\org.eclipse.jdt.core.prefs
?????文件????????470??2015-07-04?10:15??dbtest\.settings\org.eclipse.wst.common.component
?????文件????????345??2015-07-04?10:15??dbtest\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2015-07-04?10:15??dbtest\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2015-07-04?10:15??dbtest\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????1427??2015-07-04?15:27??dbtest\build\classes\com\jkxy\conn\conn.class
?????文件????????760??2015-07-04?14:51??dbtest\build\classes\com\jkxy\model\userTable.class
?????文件???????1395??2015-07-04?15:48??dbtest\build\classes\com\jkxy\service\userservice.class
?????文件????????472??2015-07-04?12:49??dbtest\build\classes\com\jkxy\test\test.class
?????文件????????562??2015-06-24?12:02??dbtest\build\classes\dbconfig.properties
?????文件???????1100??2015-07-04?11:57??dbtest\build\classes\util\PropertiesUtils.class
?????文件???????1280??2015-07-04?15:27??dbtest\src\com\jkxy\conn\conn.java
?????文件????????409??2015-07-04?14:51??dbtest\src\com\jkxy\model\userTable.java
?????文件????????842??2015-07-04?15:48??dbtest\src\com\jkxy\service\userservice.java
?????文件????????275??2015-07-04?11:22??dbtest\src\com\jkxy\test\test.java
?????文件????????562??2015-06-24?12:02??dbtest\src\dbconfig.properties
?????文件????????506??2015-07-04?11:57??dbtest\src\util\PropertiesUtils.java
?????文件?????????63??2015-07-04?13:02??dbtest\WebContent\css\st
?????文件????????641??2015-07-04?14:24??dbtest\WebContent\index.jsp
?????文件?????????39??2015-07-04?10:15??dbtest\WebContent\me
?????文件????????762??2015-07-04?14:40??dbtest\WebContent\validate.jsp
?????文件?????537303??2015-05-11?10:27??dbtest\WebContent\WEB-INF\lib\sqljdbc4.jar
?????文件????????652??2015-07-04?14:22??dbtest\WebContent\WEB-INF\web.xm
?????目錄??????????0??2015-07-04?10:53??dbtest\build\classes\com\jkxy\conn
?????目錄??????????0??2015-07-04?13:05??dbtest\build\classes\com\jkxy\model
?????目錄??????????0??2015-07-04?14:28??dbtest\build\classes\com\jkxy\service
............此處省略24個文件信息
評論
共有 條評論