javaÁ´½ÓMySQLÊý¾Ý¿âÎÊÌâ - Java / Eclipse
class DBUtil{
private final static String DBDRIVER="com.mysql.jdbc.Driver";
private final static String DBURL="jdbc:mysql://localhost:3306/warehouse";
private final static String DBUSER="root";
private final static String DBPASSWORD="";
public static Connection getConnection(){
try{
Class.forName(DBDRIVER);
Connection conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
return conn;
}catch(ClassNotFoundException e){
System.out.println("Êý¾Ý¿âÇý¶¯²»´æÔÚ");
System.out.println(e.getMessage());
}catch(SQLException e){
System.out.println("Êý¾Ý¿âÁ¬½Ó´´½¨²»³É¹¦");
System.out.println(e.getMessage());
}
return null;
}
public static void close(Connection conn){
if(conn!=null){
try{
conn.close();
}catch(SQLException e){
System.out.println("¹Ø±ÕÊý¾Ý¿âÁ¬½Ó³ö´í");
System.out.println(e.getMessage());
}
Ïà¹ØÎÊ´ð£º
JSPÒ³ÃæÖÐÓжà¸öradio°´Å¥
JSPÒ³Ãæ½«²ÎÊýPOST¸øservlet
ÒªÇóÈçÏÂ;
1.Ñ¡ÔñÒ»¸öradio£¬µ÷ÓÃservlet servletÖиù¾Ý²ÎÊýµ÷ÓÃÆäËû½Ó¿Ú£¬³ý·ÇÑ¡ÖиÃradio²¢µã»÷JSPÖеÄʵР......
ÎÒJSPµÄÒ³ÃæÊÇ£º
<%@ page language="java" contentType="text/html; charset=gb2312"
%>
<script>
function Save(){
xmlHttp=GetXmlHttpObject()
if(xmlHttp==nul ......
ÎÒÔÚ javaºËÐļ¼ÊõÉÏ ¿´ÁËÒ»¸ö ÀûÓà Java socket emailµÄÀý×Ó ¿ÉÊÇÔõôҲ ²»³É¹¦ Ϊʲô£¿
Ô´Âë
Java code:
package cn.com.test.email;
import java.awt.GridBagLayout;
import java.awt.event.Action ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
ÇëÎÊ´ó¸çÃÇÕâ¸ösql Óï¾äÓ¦¸ÃÓÃJavaÀïµÄÄǸöÊý¾Ý¿â²Ù×÷·½·¨£¿ ......
id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......